Re: Data Structure with Array in SQL Call Not Allowed?

[Michael Ryan <michaelrtr@xxxxxxxxx>]

No, it's a stored procedure that I created like this:

CREATE PROCEDURE NEWSYS/GETWCS522R(IN INPOSTAL CHAR ( 6), OUT
OTDELDS CHAR ( 350)) LANGUAGE RPGLE SPECIFIC NEWSYS/GETWCS522R NOT
DETERMINISTIC READS SQL DATA EXTERNAL NAME 'NEWSYS/WCS522R'
PARAMETER STYLE GENERAL

On Wed, Nov 3, 2010 at 9:34 AM, Bryce Martin <BMartin@xxxxxxxxxxxx> wrote:

> This is a UDF and not a Stored Procedure correct?
>
>
> Thanks
> Bryce Martin
> Programmer/Analyst I
> 570-546-4777
>
>
>
> Michael Ryan <michaelrtr@xxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 11/03/2010 08:59 AM
> Please respond to
> RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
> cc
>
> Subject
> Data Structure with Array in SQL Call Not Allowed?
>
>
>
>
>
>
> I'm getting this compile error:
>
> SQL0312: Position 44 Variable WKOTDELDS not defined or not usable.
>
> on this code:
>
>     D WkInPostal      S              6
>
>     D WkOtDelDS       DS
>     D  WkOtDelArr                   35    Dim(10)
>     D   WkOtDelDay                  30    OverLay(WkOtDelArr:*Next)
>     D   WkOtDelAmt                   5    OverLay(WkOtDelArr:*Next)
>
>       Exec Sql
>         Call GetWCS522R( :WkInPostal,
>                          :WkOtDelDS);
>
> IIRC, there's something about arrays in data structures with SQL, but I
> couldn't find it in the archives. I'm at V5R4.
>
> Do I need to *not* use this type of parameter in embedded SQL?
>
> Thanks!
> --
> 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 message (including any attachments) is intended only for the use
> of the individual or entity to which it is addressed and may contain
> information that is non-public, proprietary, privileged, confidential, and
> exempt from disclosure under applicable law. If you are not the intended
> recipient, you are hereby notified that any use, dissemination,
> distribution, or copying of this communication is strictly prohibited. If
> you have received this communication in error, please notify us and destroy
> this message immediately. ---
> --
> 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.