where will u check for sqlcode ?
Answers were Sorted based on User's Feedback
Answer / shaan
Be sure to include sqlca in working storage section.
Then you can check sqlcode from the copybook variable SQLCODE.
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / guru
If you dont include SQLCA, Define SQLCODE and SQLSTATE as
working storage variables and This will suffice
Is This Answer Correct ? | 2 Yes | 0 No |
What is database reorganization?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
how to check the table is empty or not?
What is a synonym? How is it used?
What will the COMMIT accomplish?
What is a collection in db2?
What is deadlock in db2?
Name the different types of Table spaces.
how to fetch multiple records without using cursor
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?