Re: RPG SQL and DS Arrays

[Alan Campin <alan0307d@xxxxxxxxx>]

IBM told me they did not support indexed arrays in SQL.

On Wed, Apr 6, 2011 at 2:12 PM, Kurt Anderson
<kurt.anderson@xxxxxxxxxxxxxx>wrote:

> Me with another SQL issue.
> Barbara's presentation states that the SQL precompiler supports all the new
> features in ILE RPG V6R1.
> http://www.nemug.com/handouts/rpg_v6r1_whats_new_col.pdf
> Maybe I shouldn't take from it that the SQL precompiler supports all ILE
> RPG functions, only the new ones, but that's what I'm doing (b/c if they're
> not I'm putting in a RFE).
>
> Here's my new issue, SQL doesn't seem to like my host data structure array
> variable:
>         Exec SQL
>           Insert into CalTypTIDP (Carry)
>               Values( :ds_CalTypTID(gReadIndex).Carry );
>
> Same definition of the DS as before:
>
>     D ds_CalTypTID    DS                  LikeDS( dsTmpl_CalTypTID )
>
>     D                                                        Dim(
> MAX_BLOCK_READ )
>
>
>
> Precompiler Error Messages (line 1301 is the "Values" line above):
>
> SQL0312  30    1301  Position 25 Variable DS_CALTYPTID not defined or not
> usable.
>
> SQL0104  30    1301  Position 24 Token : was not valid. Valid tokens: (.
>
> SQL0104  30    1301  Position 37 Token ( was not valid. Valid tokens: UNION
>
>                     EXCEPT INTERSECT.
>
> Thanks for the help,
>
> Kurt Anderson
> Sr. Programmer/Analyst
> CustomCall Data Systems
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.