What is the SQL Communications Area and what are some of
its key fields?
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 |
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a db2 tablespace?
Is db2 free?
if i made sme changes in sub pgm wht r the things to be done for this ?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What happens to a cursor after a commit?
What is runstats db2?
Write a query to extract first 5 characters of a name in the column Stud_Name?
what is differnece between DROP TABLE & DELETE TABLE .
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is isolation level?
how can u nderstand the sql stmts executed successfully or not ?