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 bind in db2?
What is runstats utility in db2?
What is the use of reorg in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is view db2?
What is the result of open cursor statement?
What is explain plan in db2?
What is cascading rollback?
How would the varchar column remarks defined?
Explain the benefits you can get from mainframe connect?
How can we retrieve the total number of records in RPG & CLLE?
What is the information associated with sysibm.syslinks table?
What is dpf in db2?
How do I import data from excel to db2?
What is difference between isnull and coalesce?