Using SQL in RPG

[ndevriendt]

Is it possible to use the following statement in SQL/400 ?

Select Top 5 * from FileX

I want to select only the first 5 records from my table

Thanks for your time and answer

Nico

 

[ndevriendt]

I have found it on my own

I'm using now Fetch First 5 Rows Only

thx for reading my question

Nico

 

[Logisticmars]

Hi,

You can, in sqlrpg, enter the next code :

SELECT * from MyLib/MyTable
where RRN(MyTable) <= 5.


Sql will return you the 5 first record of the file.



By.