Interested to Buy Any Domain ? << Click Here >> for more details...
What is the SQL Communications Area and what are some of
its key fields?
- 1 Answers
- 5576 Views
- I also Faced
- E-Mail Answers
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 |
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)
i want to delete 20th million record how ?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
How does DB2 store NULL physically?
What is copy pending and check pending in db2?
What is a db2 cursor?
List out the three types of page locks that can be held.
What will the FREE command do to a plan?
What is reorg in database?
What does it mean if the null indicator has -1, 0, -2?
What is null in db2?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
COBOL 
