What is sqlca and why is it needed in any cobol-db2 program?



What is sqlca and why is it needed in any cobol-db2 program?..

Answer / vegeta

Sqlca is SQL communication area.SQLCA will have all the information like return code, error id, error details etc,. after the DB2 query execution.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More COBOL Interview Questions

How can I find the maximum value of a field in a file while reading the file dynamically? without using sort function. Suppose i have a file with fields Timestamp, description, teamname, teamnumber.. i have read the file till end and find the maximun value of timestamp which is not in sorted order.. can we use function max(timestamp)?

1 Answers   CGI,


what will be the output when a)pic 9(6)value 000178 is moved to pic ***,***. b)pic 9(5) value 57397 is moved to pic $$,$$9.

5 Answers  


How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length

2 Answers   IBM, Wipro,


COMP field occupy ?

2 Answers  


How do you define a sort file in JCL that runs the COBOL program?

6 Answers   Syntel,






I want ALL ERROR codes in VSAM

3 Answers   American Express, TCS,


How do get the result of your program directly on your pc?

0 Answers   UST,


Can we redefine the field of x(200) to less than 200?

0 Answers  


how to display comp3 variables reply soon ?

4 Answers   Patni,


what is search and searchall?what is the diffrence between them?give an best example?

3 Answers   BirlaSoft,


what is SYNCHRONIZATION?

3 Answers   Syntel,


why mainframe we use not like java as frontend oracle as backend. or not word excel.In there also huge ammount data stored.

2 Answers   TCS,


Categories