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 do you mean by cursor?
what is the role of the cursor in db2?
How many clustering indexes can be defined for a table?
How many types of page locks can be held in db2?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
what is the difference between normal select query and currosor
Describe major components of db2?
How to resolve -504 sql code in DB2?
What are types of indexes?
How to find primary key of a table in db2?
What is an alias and how does it differ from a synonym?
What is the purpose of the QUIESE Utility?