Re: RPG SQL and DS Arrays

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.