Interested to Buy Any Domain ? << Click Here >> for more details...
how can we retrieve the 100 records of the file ?
- 2 Answers
- 8372 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 |
What is REORG? When is it used?
How do you check for a null value in a db2 column?
How to check sequence on a table in db2?
What is db2 instance?
How to resolve deadlock issue
What is lock contention?
Q3. How will you fetch duplicate values from a DB2 table?
What is runstats db2?
Can we declare DB2 HOST variable in COBOL COPY book?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What's the difference between DB2 active log and archive log? Thanks a lot...
what is rebinding ?
COBOL 
