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
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is lock escalation in db2?
What is the purpose of using commit?
Explain packages.
List down the types of triggers in the db2 database?
What is meant by explain?
What is the role of data manager in the db2 database?
Which are the db2 tools to protect integrity of the database?
How can deadlocks be resolved?
What is db2 purescale?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is isolation level in db2?
What are iseries servers?
What is the difference between drop table and delete table?