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 is a buffer pool?
What is index in db2?
Name some fields from SQLCA
I use CS and update a page. Will the lock be released after I am done with that page?
How to check sequence on a table in db2?
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??
Can you search give an array in the WHERE clause of a db2 query?
What will the FREE command do to a plan?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What are the full forms of spufi and dclgen and why are they used?
What is check constraint in db2?
How to fetch the uncommited data from table ?