how can we retrieve the 100 records of the file ?
- 2 Answers
- 8622 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lu
your qestion is not clear ??? first 100 rows or 100 rows
any where ??
this is FIRST 100 row :
SELECT * FROM TABLE
FETCH FIRST 100 ROWS ONLY
now if u want retrieve 100 rows in any table, you have to
create a counter ....
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / anjireddy vintha
select * from tabblename where rownum<101
| Is This Answer Correct ? | 3 Yes | 4 No |
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
Explain the function of data manager.
What happens to a cursor after a commit?
cobol-db2 runjcl please?
How do I copy a table in db2?
What is scrollable cursor in db2?
How can you split a table in to exactly half?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is innodb buffer pool?
COBOL 
