How does one remove entries from the SCT02 table?
Answer / s
When a plan is dropped it removes the entries from SCT02
table.
Is This Answer Correct ? | 3 Yes | 0 No |
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What can the SET option of the Repair Utility accomplish?
What are the advantages of using a PACKAGE?
What is DCLGEN?
What is query for your birthday date should be in hours,minute and seconds format?
What are host variables in db2?
Which component is responsible for processing sql statements and selecting access paths?
What are data types?
wht are the restrictions for union ?