Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 10757 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish.klnm
exec sql
select * from table222 where count(*) > 9
end-exec.
| Is This Answer Correct ? | 0 Yes | 14 No |
Post New Answer View All Answers
Explain what are the various isolation levels possible?
How do we specify index to include or not during bind process.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Mention the location where the output received from explain statement is stored.
How to execute stored procedures?
Is db2 relational database?
How to resolve deadlock issue
How can you find out the # of rows updated after an update statement?
What is buffer pool in the db2 database?
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?
What is the difference between using bind () and rebind () methods of naming class?
What is meant by dclgen?
what is db2 restart?
What is the difference between spufi and qmf?
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
