Answer Posted / s
Packages are single bound DBRM. When there is an change
made to the application pgm, it requires only the bind of
the package as opposed to binding the whole plan if the
DBRM was directly bound to the plan.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How will you return the number of records in table?
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.
Mention the definition of cobol in varchar field.
How do I create a view in db2?
What is the role of schema in the db2 database?
Can we delete records from view?
How do you pull up a query which was previously saved in qmf?
How can you quickly find out the # of rows updated after an update statement?
What's The Percentage Free Space ?
Why cursor is used in db2?
How to find schema of a table in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is reorg and runstats in db2?
What is the difference between cursor stability and repeatable read isolation levels?
How to connect to db2 database from windows command line?