How to fetch into an array using dynamic SQL

Is is possible to fetch multiple fields into an array with dynamic SQL? I'm using dynamic because the file name is passed to the program.
The actual number of "repeating" fields is much larger than the five I am displaying.

StmtSQL = 'SELECT ' +
'max(RC01), max(RC02), max(RC03), max(RC04), max(RC05)' +
' FROM ' + InputFileName ;

Exec SQL PREPARE S1 FROM :StmtSQL ;
Exec SQL DECLARE C1 CURSOR FOR S1 ;
Exec SQL OPEN C1 ;

// Codes is defined as an array with the corresponding number of buckets as
// the fields I'd like to populate.
Exec SQL FETCH C1 INTO :Codes ;

The SQL pre-compiler complains:
SQL0312: Position 32 Variable CODES not defined or not usable. Reason: No declaration for the variable exists, the declaration is not within the current scope, or the variable does not have an equivalent SQL data type.

Is there a syntax that would work to populate the array?

-mark