Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7680 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
Which component is responsible for db2 startup and shutdown?
Explain about mirror activator disk mirroring?
What is the connection string to connect to the DB2 Database ?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Which components manage deadlocks in db2?
How do you find the maximum value in a column in db2?
Why do chiropractors use drop table?
Can you use max on a char column?
When the like statement is used?
How is the value function used?
what is diffrence b/w file-aid tool and file-aid utility???
What is the difference between cursor stability and repeatable read isolation levels?
What is dbrm? When it will be created?
What is runstats db2?
What is null indicator in cobol db2?
