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?

Question Posted / guest

1 Answers
5397 Views
I also Faced
E-Mail Answers

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

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

how to get duplicate records from tables?write qurey for this?

4 Answers ANZ,

What is ALTER ?

3 Answers

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers

what is datacom db?

2 Answers CSC,

what is the responsibility of the construction superintendent

0 Answers Almco,

What are iseries servers?

0 Answers

i want to delete 20th million record how ?

4 Answers IBM,

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers Accenture,

How to execute stored procedure in db2 command editor?

0 Answers

What is the format (internal layout) of ?TIMESTAMP??

1 Answers

how to identify the pseudo conversation by seeing the program

2 Answers DELL,

can we view the access paths created by dbrm ? how ? thx

2 Answers IBM,

For more DB2 Interview Questions Click Here