What is the SQL Communications Area and what are some of
its key fields?
Answer / s
SQL CA is a collection of variables that is updated after
the execution of an SQL statement.
SQLCODE - SQL return code indicates if the execution was
successful or not and no data found conditions.
SQLSTATE - SQL return codes that can be used to test
specific error conditions.
SQLERRD(3)-Contains the no. of rows updated/inserted/deleted
Is This Answer Correct ? | 2 Yes | 0 No |
What are the four lockable units for DB2?
How do you retrieve the data from a nullable column?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
How do we specify index to include or not during bind process.
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
Explain package in db2 and its advantages?
What do you do to keep the cursor from closing after a commit?
What is the difference between bind and rebind in db2?
How Plan is created while executing the query using SPUFI?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What are db2 objects?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?