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
- 5615 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 |
Is db2 a programming language?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is the use of dclgen in db2?
is it compulsory commitment control in journal?
What is a composite index and how does it differ from a multiple index?
List down the data types in the db2 database.
What is a system catalog table in db2?
Why do we use cursor?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
How would you find out the total number of rows in a db2 table?
How many sub queries can you combine together ?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
COBOL 
