Use the SELECT - SQL Command - INTO or TO Clause to query tables and direct query results to an array.

If an array does not exist and the SQL SELECT Statement returns one or more records, the command creates an array. An existing array is re-created to accommodate the query results.

Note   If the SQL SELECT statement does not return any records, an existing array remains unchanged and may contain previous results. If an array does not exist, the command does not create one. Consider using the _TALLY System Variable to determine if a SQL SELECT statement returns any records.

Example

In the following example, SELECT - SQL directs its query results to an array named RESULTS:

Copy Code

SELECT DISTINCT a.cust_id, a.company, b.amount ; FROM customer a, payments b ; WHERE a.cust_id = b.cust_id INTO ARRAY results DISPLAY MEMORY LIKE results RESULTS Priv A TEST ( 1, 1) C "000004" ( 1, 2) C "Stylistic Inc." ( 1, 3) N 13.91 ( 13.91000000) ( 2, 1) C "000008" ( 2, 2) C "Ashe Aircraft" ( 2, 3) N 4021.98 ( 4021.98000000) ( 3, 1) C "000010" ( 3, 2) C "Miakonda Industries" ( 3, 3) N 9.84 ( 9.84000000)

See Also