I want to fetch the 10th row of a table which has been
changed.How can I do it without going thru all the rows.
Answer Posted / divya,roshini,tiny
use scrollable cursor for fetching the 10th row
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How is the value function used?
Explain packages.
What is check constraint. Explain with example.
How will you return the number of records in table?
How do I delete a table in db2?
How to connect to db2 database from windows command line?
What is a storage group (stogroup)?
What is the role of schema in the db2 database?
Is schema the same as database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Explain correlated sub-queries.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How many databases are there?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How to run db2 command in windows?