Try this:

DIMENSION a_tables[1]
SELECT myField;
  FROM MyTable;
  WHERE NOT EMPTY(myField);
  INTO ARRAY a_tables

You can also use the FOR clause of COPY TO...but you'd also have to correctly dimension the array