What is the SQL Communications Area and what are some of
its key fields?
- 1 Answers
- 5174 Views
- I also Faced
- E-Mail Answers
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 are the functions in DB2?
What is copy pending status in db2?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What are the uses of db2 optimizer?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is schema in db2?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What do you mean by NOT NULL? When will you use it?
How to create a table using embedded sql?
What is temporal table in db2?
What is catalog database in db2?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
COBOL 
