Well, well, well!
It's Raghunandan! Hehe. How have you been? I am assuming you are
using DB2 on LUW! Hehe. If you are in the Control Center, click on
"Tools, click on "Tool Settings", click on "Command Editor", uncheck the
box next to "Automatically commit SQL statements". Add the option
parameter (+c) to turn off autocommit on all statements issued through
the db2 command processor.
Example:
db2 +c insert into mytable .....
If you run a batch of DML statements (insert, delete, update), include
the "rollback" command in it.
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Raghunandan
[mailto:db2udbdba-ezmlmshield-x30589812.[Email address protected]
Sent: Wednesday, August 29, 2007 3:02 AM
To: LazyDBA Discussion
Subject: equivalent of set noexec on
Hi All,
What is the equivalent of the "set noexec on" statement in DB2.
Regards
Raghu
*****************************************************************
This e-mail and its attachments contain confidential information from
HUAWEI, which is intended only for the person or entity whose address is
listed above. Any use of the information contained herein in any way
(including, but not limited to, total or partial disclosure,
reproduction,
or dissemination) by persons other than the intended recipient(s) is
prohibited. If you receive this e-mail in error, please notify the
sender by
phone or email immediately and delete it!
*****************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page