How to test SQL -911 error while developing COB-DB2 program
Answers were Sorted based on User's Feedback
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 |
Answer / Anupam Bharati
SQL -911 is a DB2 error indicating that the database manager terminated abnormally. To test this error, you can intentionally cause such an event by executing commands that would overload the system or by manually stopping the database server while the program is running. However, it's important to note that testing SQL errors should be done carefully and within controlled environments to avoid data loss or system damage.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is schema the same as database?
What is a SELECT statement?
What is difference between isnull and coalesce?
What is rct?
What is a synonym? How is it used?
What is db2 connect?
what is the name of the default db2 catalog database?
What is index in db2?
When is the skeleton cursor table created?
What is the difference between spufi and qmf?
How to know the primary key of a table without defining the primary key in the table?
What is the connection string to connect to the DB2 Database ?