Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 6356 Views
- HCL, I also Faced
- E-Mail Answers
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 |
Define check constraint.
How to create db2 table in mainframe?
my project is insurance management system,how to explain my work environment in interview?
Explain about mirror activator disk mirroring?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
How to insert more than one record using insert?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
what's the error code for Unique Index Violation?
What is the maximum size of a char data type in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is the physical storage length of the data types date, time, and timestamp?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
COBOL 
