Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Replication Issues
Hi ! We have a database replication, which replicates AIX master to Windows NT replica. The problem is, when we start the client apply process (asnapply.exe) It shows up in "db2 list applications" command for first 2-3 minutes, but after that nothing shows up on "db2 list... -
Limiting number of rows retrieved and resuming from next row
Is there any similar clause in SQL as "FETCH FIRST x ROWS ONLY" to fetch rows after a certain number ? For example, I am using Select * From <table_name> Where <blah_blah_blah> Fetch first 100 rows only; Now if I wanted to fetch next hundred rows, how would I do it ? I don't won't... -
Cannot find row on Table
Are you running the same exact query in both QMF and in your program ? Sometimes, when you are selecting only some of the column values in your query then the result will be different from when you select *.
