what is a plan and how do you refer the plan in the
program?
- 2 Answers
- 6032 Views
- Xansa, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do I import a csv file into db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is runstats and reorg in db2?
What is the function of logging in the db2 database?
How can we read records for specific member in CL? AND rpg?
Can we delete records from view?
What are the various isolation levels possible?
How to view db2 table structure?
Why do chiropractors use drop table?
What is bind plan?
What is declare cursor?
What is the use of reorg in db2?
Explain in detail about buffer manager and its functionalities?
Why select is not preferred in embedded sql programs?
Is the primary key a clustered index?
