The following example shows the declaration of a host structure and an indicator array followed by an SQL statements that could be used to retrieve the data into the host structure.
dcl 1 games,
5 sunday,
10 opponents char(30),
10 gtime char(10),
10 tv char(6),
10 comments char(120) var;
dcl indicator(4) fixed bin (15);
exec sql
fetch cursor_a
into :games.sunday:indicator;