I want to make a simple page that show only 10 records from one big file.
If I'll use somehting like "SELECT * FROM V40BPCSF.IIM" I'll get all Items in IIM file (1000K records) and it is taking too much time.
Is there any way to make direct connection, and then fetch 10 time, keeping the current record so I could continue from that specific location on the next page ???
PS(1) - "SELECT TOP 10 " is not working on the AS400...