What is the SQL Communications Area and what are some of
its key fields?
- 1 Answers
- 4471 Views
- I also Faced
- E-Mail Answers
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 are bind parameters in db2?
What is a db2 tablespace?
What is a buffer in memory?
What is the use of reorg in db2?
List some fields from sqlca?
What are db2 tables?
What is a storage group (stogroup)?
How do I optimize a query in db2?
How can you count the number of rows from a table tab?
Explain about cursor stability?
What is difference between isnull and coalesce?
How do you select a row using indexes in db2?
What is a plan and package in db2?
What are the prerogatives?
What is image copy in db2?
