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 |
What information is used as input to the bind process?
What is UNION,UNION ALL?
How is a typical DB2 batch program executed ?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
how can u understand the end of the table ?
i have a db2 variable how do u declare tht into working storage section ?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
How is the SUBSTR keyword used in sql?
Can one database have multiple instances?
What is db2? Explain.
How to design maps