Interested to Buy Any Domain ? << Click Here >> for more details...
what is a plan and how do you refer the plan in the
program?
- 2 Answers
- 7124 Views
- Xansa, I also Faced
- E-Mail Answers
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 |
Name the different types of Table spaces.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Can there be more than one cursor open for any program?
can we view the access paths created by dbrm ? how ? thx
What is a data page?
When reorg is used?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What does DML stand for and what are some examples of it?
Why select is not preferred in embedded sql programs?
What is SPUFI?
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 execute stored procedures?
COBOL 
