
DB2 beginner question regarding commit/rollback
Well, there is a DB2SET variable called DB2OPTIONS.
"Sets command line processor options."
I just wonder what's it for. (??? hehe)
Maybe you can set the command line options for
a user,
a node,
an instance or
global level?
I think that could do the job but i never tried it, so...
PM
Quote:
> You can't set it at the server to apply to clients. This is a client
> setting.
> I'd recommend you investigate seriously the DB" COMMAND REFERENCE manual
> that should be online with your install.
> This will discuss Command options and how to set them for one time, the
> session or permanent.
> HTH, Pierre.
> > Thanks for your help! I got it working....
> >>Yes, by default autocommit is on, so in your case insert was commited
> > before
> >>rollback. See the CLP option to turn autocommit off (+c).
> > From what I understand you do this by entering "db2 +c" at the command
> > prompt (Strange that the '+' character is used for a program argument
> > instead of the "standard" characters '-' or '/').
> > Is there any way this can be set to apply for all users on all databases
as
> > default (a server setting maybe?)
> > regards
> > Lee Francis