What is the SQL Communications Area and what are some of
its key fields?
Answer / 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 |
Is db2 relational database?
Where is the output of EXPLAIN stored?
What is a DB2 bind?
what are extents?
why we go for SPUFI for creating tables or for sql queries?
how do we solve soc 7 and soc4 ?
What is cloudant database?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is the information associated with sysibm.syslinks table?
What is innodb buffer pool?
What is difference between isnull and coalesce?
What is a db2 tablespace?