Answer Posted / angoca
The commit will close the cursor if this last was not
declared with the 'with hold' option.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What are the uses of db2 optimizer?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is performance tuning db2?
What are concurrency issues?
What is the role of data manager in the db2 database?
What is db2 optimizer?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is query_cache_limit?
Is the primary key a clustered index?
Which command is used to remove all rows from a table?
Can we delete records from view?
What is runstats db2?
What is a buffer in memory?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the use of with ur in db2?
