Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vat
Contains information about access paths and the internal
form of the SQL for an application plan. Entries in this
table are made when a plan is bound (BIND PLAN) and deleted
when a plan is freed (FREE PLAN). This table is also loaded
into memory at execution time
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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 ?...
What is the difference between drop table and delete table?
What is bufferpool in db2?
What is the maximum size of a char data type in db2?
What is table space in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are concurrency issues?
List out the data types available.
How do we specify index to include or not during bind process.
What kind of database is db2?
List out the buffer pools in db2
What is the syntax for FETCH in DB2 ?
What is iseries database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is an instance in db2?
