How to test SQL -911 error while developing COB-DB2 program

Question Posted / valmiki1980

How to test SQL -911 error while developing COB-DB2 program..

Answer / valmiki1980

1. put autocomit No in spufi and run insert command
2. run the insert command thru cob-db2 program.
this results -911 error

Is This Answer Correct ?

1 Yes

1 No

More DB2 Interview Questions

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

What is the function of logging in the db2 database?

What action db2 takes when a program aborts in the middle of a transaction?

how to resolve -811 error. give clear explination

Which one allows duplicate values Union or Union All ?

What is a db2 schema?

What is data manager?

What does db2 plan contain?

How does coalesce work?

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

What is the max length of sqlca?

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

For more DB2 Interview Questions Click Here