What is the SQL Communications Area and what are some of
its key fields?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between oracle and db2?
What is deadlock in db2?
What are db2 objects?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What are packages in db2?
What does db2 mean?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What's The Percentage Free Space ?
what is the role of the cursor in db2?
What is dbrm?
Mention the definition of cobol in varchar field.
What parameters are used to control the free space in DB2?
Is db2 a mainframe database?
What is the difference between db2 and oracle?
Why do we use cursor?