select 100 records from million records ?
Answers were Sorted based on User's Feedback
Answer / prachi
SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;
This will fetch 1st 100 records
Is This Answer Correct ? | 20 Yes | 0 No |
Answer / ankit.:-)
if u want to fetch first 100 go for
select * from tablename fetch only 100 rows;
this will select only 100
Is This Answer Correct ? | 5 Yes | 5 No |
Explain dclgen.
What are iseries servers?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
B37 abend during spufi?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is REORG? When is it used?
how can we retrieve the 100 records of the file ?
how to resolve -811 sqlcode .give clear explaination
What's The Error Code For Unique Index Voilation?
Explain in brief how does db2 determine what lock-size to use?