Answer Posted / ms. stanley
To create the most optimal path for the SQL Queries in the
program
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between nvl and coalesce?
What is the difference between bind and rebind in db2?
Define predicate?
What language is db2 written in?
What is a Foreign Key?
What is multi row fetch in db2?
What is declare cursor?
Before you give the explain statement, what are the prerogatives?
What do you mean by commit and rollback?
What do you mean by rollback?
Explain the function of data manager.
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.
What is package in cobol db2?
What is null in db2?
What is a db2 cursor?
