assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
What is DCLGEN ?
How can the duplicate values be eliminated from db2 select?
How do I add a column in db2?
what is plan? is plan executable or package?
What are the isolation levels possible ?
how to identify the pseudo conversation by seeing the program
How does DB2 use multiple table indexes?
What is a plan and package in db2?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
Are views updateable?
Explain various types of locks in db2?