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

What is the error code -803 ?

what is difference between Plan and Package

Write a query to retrive partial string.

What is nvl in db2?

Differentiate between cs and rr isolation levels? Where do you specify them?

What is the database descriptor?

What is ACQUIRE/RELEASE in BIND?

How and when does the db2 enforces the unique key?

What are the 2 sqlcodes that are returned?

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

What are the functions of Bind?

What is query_cache_limit?

For more DB2 Interview Questions Click Here