Specify number of lines for Transfer Receive question

Hi

the TOP instruction which would normally be used in SQL queries to achive this is not supported by AS400 SQL. The instruction required to achieve your goal is FETCH

e.g.

  Select * FROM MYLIB/MYDB

  FETCH FIRST 20 ROWS ONLY

This should return the first 20 rows from MYDB.

Hope this helps.

Is FETCH FIRST 20 ROWS ONLY to be entered into the Additional TSO Parameters window? I get an error message: TRANS18 Incorrect option specified: file transfer canceled.

Is FETCH FIRST 20 ROWS ONLY to be entered into the Additional TSO Parameters window? I get an error message: TRANS18 Incorrect option specified: file transfer canceled.

Apologies, I had assumed you were attempting an AS400 SQL query.

In terms of IND$FILE TSO downloads, there is no parameter /option to limit the number of lines which you download.

OK thanks