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

In CICS/VSAM every file that is accessed should be defined in FCT. we have CICS READ, WRITE, BROWSE commands for VSAM files. How does it work with DB2 tables. It know it has to do with the plan. Please expain with examples.

1 Answers  


Without using move verb how to move one variable to another.

5 Answers  


If you are current on the owner of a set, what is the difference between an obtain next and obtain first? Actually in which topic will we use dis???Plz explain it clearly

0 Answers  


How can we find out wether to declare the data items like Integer, Char,Comp? If comp types how can we decide wether it is Comp and Comp3.How it is? Please Explain... Cheers.

1 Answers   Syntel,


created cluster using IDCAMS ..that is empty ..when i write a program for read using Input ..wil it open the cluster or gives any error?

2 Answers   HCL,


What is Alternate Index ? How is it different from regular index ?

2 Answers  


What is Control Break processing ?

1 Answers   iGate,


what is S04E error in jcl?

11 Answers   IBM, L&T,


consider the following progrm statements MOVE 0 TO SW.NO.OF.REC PERFORM PRI-OUT UNTIL SW=1 DISPALY NO.OF.REC STOP RUN PRE-OUT READ IN-FILE AT END MOVE 1 TO SW WRITE OUO-REC FROM IN-REC ADD 1 TO NO.OF REC if the IN-FILE contains 1000 records what value will be displayedafter the PERFORM is over?assume that N0.OF.REC has PIC 9(4) a.1000 b.1001 c.1 d.none of the above since there is a syntex error

4 Answers   TCS,


what is label record is standard or omitted in file description of data division?

3 Answers   IBM, TCS,


How do you come out of an EVALUATE statement?

3 Answers  


How to define a array dynamically.....

5 Answers   Fidelity,


Categories