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?
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 |
How does db2 sample database connect?
How do I delete a table in db2?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
what's the error code for Unique Index Violation?
Where are plans stored?
What are union and union all?
What is the syntax for creating a table in the db2 database?
What is a host variable?
What is lock contention?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is ibm db2 used for?
can we view the access paths created by dbrm ? how ? thx