In cursor program perform para varying until 1 by 1 fetch para cursor------clos

In cursor program perform para varying until 1 by 1
fetch para cursor------close para
in the blank what will come for confirming in the database?

Question Posted / jabi

1 Answers
6367 Views
HCL, I also Faced
E-Mail Answers

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank..

Answer / ekalavya

You can read the variables from SQLCA. For eg. you can
check SQLCODE.

Include SQLCA in the working storage of the progarm.

EXEC SQL
INCLUDE SQLCA
END-EXEC.

then check for the SQLCODE after your SQL query.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More DB2 Interview Questions

What is the difference between group by and order by?

2 Answers IBM, TCS,

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers

What is plan in cobol db2?

0 Answers

what is a plan and how do you refer the plan in the program?

2 Answers Xansa,

what is a collection?

2 Answers

What is a db2 tablespace?

0 Answers

what needs to be done if a table is in copy pending / check pending status?

5 Answers Xansa,

What is correlated subquery?