1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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


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

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,




Name the lockable units in DB2?

0 Answers  

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

What is a composite index and how does it differ from a multiple index?

1 Answers  

What is the significance of DB2 free space and what parameters control it?

1 Answers  

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

select 100 records from million records ?

2 Answers   Verizon,

What do you mean by cursor?

0 Answers  

For more DB2 Interview Questions Click Here
Categories