What is the SQL Communications Area and what are some of
its key fields?
Answer Posted / s
SQLCA is a collection of variables that is updated after
the execution of the SQL statment.
The values in these variables tells if the SQL completed
successfully or not and for testing specific error
conditions.
SQLCODE, SQLSTATE, SQLERRD(3)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to restart a DB2 program?
What is phantom read in db2?
What is db2 and what is the use of db2 optimizer?
What are the prerogatives?
What is host variable in db2 cobol?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is dbrm? What it contains? When it will be created?
How to get the ddl of a table in db2?
What is collection in db2 bind?
What is the connection string to connect to the DB2 Database ?
What is a storage group (stogroup)?
How to take backup of table in db2?
How can deadlocks be resolved?
What is bind and rebind in db2?
What is the difference between dbm cfg and db cfg file in db2 ?