Parameters

SELECT supports the following parameter:

number: Specifies an integer between 0 and 999,999,999. 0 is the default and is used to select every record.

This example syntax copies every tenth record that contains a DOB-YEAR field value of N'1945'.

COPY,
  LAYOUFILE(LAYOUT),
  SELRECIF(DOB-YEAR,EQ,N'1945'),
    SELECT(10)