• SCATTER transfers data from a single table record to an array.

• COPY TO ARRAY transfers data from a series of records to an array.

• SELECT - SQL can transfer the results of a query to an array. For details about SELECT - SQL, refer to the topic Arrays and SELECT - SQL.

SCATTER and COPY TO ARRAY differ in the following respects:

• SCATTER transfers data from the current record in the current table. COPY TO ARRAY can transfer data from multiple records in the current table.

• The SCATTER BLANK option automatically creates an array having elements the same size and type as the fields in the table, but the array elements are empty.

• The SCATTER VAR option automatically creates a set of variables having the same size, type, and name as the fields in the table.

Reference

Concepts

Other Resources