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 the use of commit ? and what is the syntax?
What is access path in db2?
What is QUIESCE?
my project is insurance management system,how to explain my work environment in interview?
What does sqlcabc has?
What is null value in db2?
Can we declare DB2 HOST variable in COBOL COPY book?
What is ibm db2 used for?
Are views updateable?
What is database reorganization?
What is netezza database?
What does the RUNSTATS Utility do?