what is a plan and how do you refer the plan in the
program?
Answers were Sorted based on User's Feedback
Answer / harsha
plan is executable.it contains access path.we will refer
plan in jcl as plan name.generally all information abt the
plan will be there in sysibm.sysplan
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / guest
The DBRM name is the program name and should be bound to a
plan before the DB2 program can be executed. The plan is
nothing but bound DBRMs or packages.
| Is This Answer Correct ? | 0 Yes | 1 No |
how we will do null data selection in cobol-db2 program
What are the two types of logging in the db2 database? Explain them.
What is image copy in db2?
What is package in db2 mainframe?
What is dbrm? When it will be created?
How to run db2 command in windows?
cobol-db2 runjcl please?
How to select the duplicate rows from a table?
What is db2 stogroup?
Which component is responsible for db2 startup and shutdown?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
How to fetch the last row from the table in SQL (db2)?