Re: How do I do a SQL select into a data structure when specifying fields?

On 05-Jul-2017 12:58 -0600, DFreinkel wrote:

I am reading data from a file into a data structure.

T_data ds qualified dim(100)
Fielda like(fielda)
Fieldb like(fieldb)
Fieldc like(fieldc)

Select fielda, fieldb, fieldc into :T_data
From myTable;

Compilers tells me SL0312 T_data is not defined or usable.

What am I doing wrong or how would I do this?

I do not want to read 1 record at a time.

As others noted, FETCH multiple rows. But if the data for the result-set is known to be necessarily limited [e.g. 100x320], then the data can be returned as one row, so in effect, the above SELECT INTO could be accomplished; the contiguous data is then /viewed/ by the program as DIMensioned proportionally. A recursive query can easily enough concatenate the originally expected-as multiple-row result-set as just one row.