Re: RPG SQL and DS Arrays

That's a bummer.

I opened up IBM's Developerworks RFE page to enter an RFE, but apparently
it doesn't include RPG.
http://www.ibm.com/developerworks/rfe/

-Kurt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Alan Campin
Sent: Wednesday, April 06, 2011 3:21 PM
To: RPG programming on the IBM i / System i
Subject: Re: RPG SQL and DS Arrays

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.

--
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.

--
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.