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
- 5102 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 is cursor with hold option in db2?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is a subselect? Is it different from a nested select?
What is an access path?
wht happens if we close cursor with cursor with hold option?
Can SQL statements/queries be included in a copybook?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is difference between rollback and commit?
How to insert more than one record using insert?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
where can we use index and subscript ? with example ?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
COBOL 
