If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
Answer Posted / sunil a
1 DBRM , 1 PACKAGE and 1 PLAN
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain the function done by data manager?
What is node in db2?
Explain what are the various isolation levels possible?
What is check constraint. Explain with example.
Explain package in db2 and its advantages?
What is copy pending and check pending in db2?
Is db2 a database?
What is dpf in db2?
What parameters are used to control the free space in DB2?
How would you find out the total number of rows in a db2 table?
What is db2 purescale?
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 ?...
How to find primary key of a table in db2?
What is the purpose of rollback and commit?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.