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
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
On which levels locks can be applied?
What does a deadlock mean in DB2?
What are the different types of base tables?
What is check constraint in db2?
What is meant by union and union all?
what is the role of the cursor in db2?
What is commit in db2?
How can deadlocks be resolved?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What does db2 blu stand for?
How to find primary key of a table in db2?
What is cloudant database?
What is access path in db2?
What is a Foreign Key?