SQL and defining data structures

I'm learning more embedded SQL, I'm doing a group/order by, so I process
the rows into a data structure.

I have a fetch like this, fetch next from c into :cx;

But the only way I can see to define the DS is to hard code the columns.
This can't be the best way

dcl-ds cx qualified inz;
TYP char(3);
SHP packed(7: 0);
SEA char(5);
STY char(20);
CLR char(10);
FAB char(10);
MOD char(10);
end-ds;

The SQL select doesn't match any specific table, it's a join of several
files.

Thanks for any advice, Art