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 |
Which command is used to remove all rows from a table?
What are common abends
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What should be specified along with a cursor in order to continue updating process after commit?
What is a predicate?
What are db2 tables?
what is the maximum number of tables that can be joined ?
what is the soft code for deadlock ?
What is runstats utility in db2?
What is a clustered index?
What are some SQL aggregates and other built-in functions?