What is the SQL Communications Area and what are some of
its key fields?



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

Post New Answer

More DB2 Interview Questions

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


What is iseries database?

0 Answers  


How can we retrieve the total number of records in RPG & CLLE?

0 Answers  


when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,


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?

4 Answers  






What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


What is the advantage in De-normalizing tables in DB2?

0 Answers  


is it compulsory commitment control in journal?

0 Answers   TCS,


What does DSNDB07 database do?

2 Answers  


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.

2 Answers   Syntel,


What is a db2 table?

0 Answers  


Categories