What is the FREE command?



What is the FREE command?..

Answer / s

FREE command drops the Plan or can be used to drop a
package.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the function of the Data Manager?

2 Answers  


How to fetch the last row from the table in SQL (db2)?

0 Answers  


we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  


Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  


What is the use of value function?

0 Answers  






What is ibm db2 database?

0 Answers  


What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,


Can any one tell me about Restart logic in DB2.

2 Answers  


What is isolation level?

4 Answers  


What are bind parameters in db2?

0 Answers  


Is Cursor exicutable ?

3 Answers   TetraSoft,


i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,


Categories