What will the FREE command do to a plan?

Answer Posted / sv kumar

it will delete that existing plan

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

7523


What is bind plan?

616


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6863


What is data manager?

612


What is the use of with ur in db2?

619






What are the 2 sqlcodes that are returned?

644


What is role in db2?

622


What is bufferpool in db2?

581


What is temporal table in db2?

605


What is a plan and package in db2?

626


How can you do the explain of a dynamic sql statement?

637


What is view db2?

626


Explain about mirror activator disk mirroring?

561


What does db2 mean?

589


What is the use of dclgen in db2?

591