Hi,

What is the DB2 equivalent for "set autocommit on" of Oracle ?

Thanks,
Sam

What interface are you using. For the CLI, autocommit is the default.

Yes, CLI interface. What should I do to mae it 'off'. Please give the SQL Plus command for the same

Thanks,
Sam

For the command:

db2 +c -tvf file-name

the "+c" will turn off autocommit. This is documented in the Command Reference in the discussion about CLI options.

If you want to turn it off permanently
set the variable db2options to +c (counterintuitive!)
using:

db2set db2options=+c

Look into the db2set -? for syntax.

BOW

Hi,

Thanks for your reply.

But, again how to trun it on, with the same statement ?


Thanks,
Sam

db2set db2options=-c

Hi,

Once again thanks for your reply.

1) Can this command be executed through DB2 JDBC driver or only it could be executed from DB2 client SQL prompt ?

2) What are these commands called as ? Are they called as "SQL Plus commands"

Please advice.

Thanks,
Sam

Hi I'm not sure if these commands can be
processed through JDBC.

As far as I know, all commands beginnig with db2* are called
db2 commands and can be invoked directly from any command prompt,
as opposed to SQL statements who can only be invoked through the CLI

But I might be wrong.

In JDBC just do con.setAutoCommit(false)

Hi ,

I am new bie to db2, I connect to db2 as client on particular ip with the credentials that are common among team but for me there will be separate session but any how wat about if i want to set the auto commit made for my session to false that is to switch off....?? Shall I execute the same statement as other statement i do fire on tables ...!! please guide..!!