Keywords › Keyword Descriptions › SELECT › Parameters

Parameters

SELECT supports the following parameter:

number

An integer between 0 and 999,999,999. A zero is used to select every record, and is the default value.

Example 1

This example syntax copies every third record from the input file.

COPY,
  SELECT(3)

Example 2

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)