What is the SQL Communications Area and what are some of
its key fields?
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 the role of the data page in the db2 database?
Explain how can you do the explain of a dynamic sql statement?
If I have a view which is a join of two or more tables, can this view be updateable?
What is cobol db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How can you quickly find out the # of rows updated after an update statement?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to run db2 command in windows?
What is rct?
Mention the different locking levels that are available in db2.
Define db2 and its databases?
What is table space in db2?
What is cascading rollback?
Comment whether the cursor is closed during commit or not.