RE: RPG SQL and DS Arrays

I had also posted this as a question on the RPG Café. I was told I should open up a DCR for it.
http://www.ibm.com/developerworks/forums/thread.jspa?threadID=367240&tstart=0

-Kurt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Kurt Anderson
Sent: Thursday, April 07, 2011 9:19 AM
To: RPG programming on the IBM i / System i
Subject: RE: RPG SQL and DS Arrays

Can anyone at 7.1 verify this?

I've read a couple RPG at 7.1 articles and they didn't mention the issue of using indexed arrays in embedded SQL (or really mention SQL).

http://systeminetwork.com/article/quick-tour-new-rpg-features-ibm-i-71 by Scott Klement http://www.mcpressonline.com/programming/rpg/ibm-i-71-first-looks-rpg.html by Joe Pluta
http://systeminetwork.com/article/rpg-iv-ibm-i-71 by Bob Cozzi

Thanks,
Kurt
ps. After reading these articles, I really want to upgrade to 7.1


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

I believe it is in 7.1

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

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.

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