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 |
What r the comman abends in db2, jcl and cobol???????
What is iseries database?
How can we retrieve the total number of records in RPG & CLLE?
when does the SQL statement gets executed when you use cursor in the application programming ?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What's the difference between DB2 active log and archive log? Thanks a lot...
How do you do the EXPLAIN of a dynamic SQL statement?
What is the advantage in De-normalizing tables in DB2?
is it compulsory commitment control in journal?
What does DSNDB07 database do?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is a db2 table?