Re: SQL and defining data structures

[Booth Martin <booth@xxxxxxxxxxxx>]

Would it help document your program if you defined the fields with 
like() instead of char()?


On 8/30/2017 1:13 PM, Jack Tucky wrote:
> 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