Db2 disables command line CLP for automatic submission

Db2 disables command line CLP for automatic submission
Db2 disables command line CLP for automatic submission

Db2 => update command options using C off -- temporarily disable automatic submission
Db2 => update command options using C on -- temporarily enable automatic submission
C: \ DB2> db2set-lr | find/I "db2option" DB2OPTIONSC: \ DB2> db2set DB2OPTIONS = + c+ C permanently disables automatic submission, and-c permanently Enables automatic submission. C: \ DB2> db2 list command options | find/I "-c"-c automatically implements OFF

C: \ DB2>

 

 

C: \ DB2> db2-c insert into c1_sched values ('A', 1)
The DB20000I SQL command is successfully completed.

C: \ DB2> db2 select * from c1_sched

CLASS_CODE DAY
----------------------------------------
A 1

1 record selected.


C: \ DB2> db2 rollback
The DB20000I SQL command is successfully completed.

C: \ DB2> db2 select * from c1_sched

CLASS_CODE DAY
----------------------------------------
A 1

1 record selected.


C: \ DB2> db2 + c insert into c1_sched values ('B', 2)
The DB20000I SQL command is successfully completed.

C: \ DB2> db2 select * from c1_sched

CLASS_CODE DAY
----------------------------------------
B 2
A 1

Two records are selected.


C: \ DB2> db2 rollback
The DB20000I SQL command is successfully completed.

C: \ DB2> db2 select * from c1_sched

CLASS_CODE DAY
----------------------------------------
A 1

1 record selected.


C: \ DB2>