Re: Date field in MODS resultset unusable...

[Rory Hewitt <rory.hewitt@xxxxxxxxx>]

Robert,

What happens if you define it as a DS array (using the DIM keyword rather
than the OCCURS keyword)?

On Tue, Aug 9, 2011 at 6:15 PM, Robert Rogerson <rogersonra@xxxxxxxxx>wrote:

> Hi all,
>
> I'm working on a macine at V7R1,
>
> I have a MODS defined as
>     d storeSalesRs    ds                  occurs(1000)
>     d   o_StoreNum                  10i 0
>     d   o_StoreName                 20a
>      *  Actual dates
>     d*   o_AFromDate                   d
>
> and later I return the result set
>         Exec SQL
>           SET RESULT SETS ARRAY :storeSalesRs for :idx ROWS;
>
> If I uncomment the date field o_AFromDate and recompile I get
> SQL5011  30     520  Position 35 Host structure array STORESALESRS not
> defined or not usable.
>
> I already attampted to set the datfmt for the SQL (SET OPTION Datfmt=*ISO)
> but this had no effect.
>
> Does anyone have any insight as to what I'm missing?
>
> Thanks,
>
> Robert Rogerson