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 types of copies can be made with the COPY Utility ?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is the use of dclgen in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
when does the SQL statement gets executed when you use cursor in the application programming ?
What is the latest version of ibm db2?
What if we fail to give values in columns declared as NOT NULL ?
How to resolve -917 sql code in DB2?
Which transaction use a command thread ?
Describe what a storage group(STOGROUP) is?
What is db2 bind?