Answer Posted / maveric
1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.
2. A host language copy book that gives the host variable definitions for the column names.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do we specify index to include or not during bind process.
Which are the db2 tools to protect integrity of the database?
What do you mean by commit and rollback?
Why select is not preferred in embedded sql programs?
How do I create a view in db2?
What is db2 and what is the use of db2 optimizer?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How can we read records for specific member in CL? AND rpg?
Is ibm db2 free?
What is null indicator in cobol db2?
What is an instance database?
Can we delete records from view?
How can you count the number of rows from a table tab?
Explain about rct 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.