When a plan is dropped it removes the entries from SCT02 table.

How does one remove entries from the SCT02 table?

Question Posted / s

Answer Posted / s

When a plan is dropped it removes the entries from SCT02
table.

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I delete a table in database?

1004

Mention the definition of cobol in varchar field.

1225

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1067

What is ibm db2 connect?

973

Define declaration generator (dclgen).

1097

Define predicate?

1103

Explain in brief how does db2 determine what lock-size to use?

1020

Where can you declare a cursor in a cobol-db2 program?

1050

What is a bind in db2?

1020

How is deadlock resolved?

1121

Which component is responsible for processing sql statements and selecting access paths?

1112

What db2 400?

1143

How do I delete a column in db2?

1090

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1169

What is check constraint in db2?

1062