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
- 5029 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is dbrm? What it contains? When it will be created?
What is db2 command?
What is dpf in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
what is the sqlcode -501
What is the difference between nvl and coalesce?
What kind of database is db2?
How many databases are there?
What is cursor in dbms?
What is a Foreign Key?
What is declare cursor?
List some fields from sqlca?
How to take backup of table in db2?
What are host variables in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
