Shall i use this query to retrieve first 4 records,
Select empno, sal from emptbl where empno < 5. like this can
we fetch first 100 records?
- 3 Answers
- 6209 Views
- I also Faced
- E-Mail Answers
Answer Posted / anju
I dont think records are stored in the sorted order of primary key in DB2. It happens only in VSAM!
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Define data page.
How to view db2 table structure?
Is db2 a programming language?
List down the types of triggers in the db2 database?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What are catalog tables in db2?
What is buffer pool in the db2 database?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is dclgen (declaration generator)?
Define db2 and its databases?
What do you mean by rollback?
What is db2 look?
How to check sequence on a table in db2?
what is utility for parm lib
How can you find out the # of rows updated after an update statement?
