What is the SQL Communications Area and what are some of
its key fields?
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 |
When is the results table for the query in a DECLARE CURSOR statement created?
Which transaction use a command thread ?
Compare a subselect to a join?
Is db2 a mainframe database?
What is the physical storage length of date data type?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What is scrollable cursor in db2?
In terms of DB2 indexing, what is the root page?
What is a cursor and what is its function?
What is the difference between bind and rebind in db2?
how do u update the faltfile into db2 table ?