What is the use of db2 optimizer?
No Answer is Posted For this Question
Be the First to Post Answer
is it possible to get -811 error when you use cursors. why?
what is check point and restart Logic ? why do we go for that ??
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What do you mean by cursor?
Highlight all the advantages that are attached to a package.
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
How will fetch last 5 rows from table in db2
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How many sub queries can you combine together ?
How can you get the number of rows impacted by the last executed query?
How to check table size in db2 sap?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?