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
- 6419 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is an instance in db2?
Explain about cursor stability?
Why do chiropractors use drop table?
What is dbrm? What it contains? When it will be created?
Which component is used to execute the sql statements?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is image copy in db2?
Mention the various locks that are available in db2.
Explain what are the various isolation levels possible?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are db2 objects?
How to resolve deadlock issue
List out the buffer pools in db2
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
