Answer Posted / tintu raveendran
It is the process of creating an executable module from the
source DBRM. Its functions are,
Checks the syntax of the SQL defined in the program (DBRM)
Checks whether the object accessed by the SQL physically
exists.
Does an authorization check.
Creates the optimum access path for the query using the
DB2 optimizer.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How can you find out the # of rows updated after an update statement?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is database reorganization?
What is release/acquire in bind?
What is null in db2?
Is db2 a mainframe?
Give the name of some fields form sqlca.
What is performance tuning db2?
Is db2 a programming language?
What is image copy in db2?
What is the clustering index in the db2 database?
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 data types used in db2 ?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.