Use the SELECT - SQL Command - INTO or TO Clausec 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)

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)

Example

See Also

Other Resources