How to resolve -502 sql code in DB2?
Answers were Sorted based on User's Feedback
what is difference between Plan and Package
Update command
How to resolve -407 sql code in DB2?
Explain dclgen.
How can we read records for specific member in CL? AND rpg?
When can an insert of a new primary key value threaten referential integrity?
What is Reorg Recovery? when will you run it?
What is cursor?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
what is the difference between normal select query and currosor
How can we define a table? How can we apply SEARCH ALL on it ?
What will the DB2 optimizer do?