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

[Bryce Martin <BMartin@xxxxxxxxxxxx>]

Ahh Vern, my bad.  You are right.  I was thinking Result Set, not 
parameter returns.  Bah, time to bury my head in my work :D


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



Vern Hamberg <vhamberg@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/03/2010 12:46 PM
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
Re: Data Structure with Array in SQL Call Not Allowed?






Bryce

Just to clarify - did you mean to says we "cannot use embedded sql for 
processing stored procedures"? Actually, we have always been able to 
process stored procedures - or maybe I should say, CALL stored 
procedures. We have not been able to use result sets from stored 
procedures - that has been the limitation until version 7.1.

If you had parameters to a stored procedure, I think they were usable on 
return, if changed. I can't swear to this - maybe AT this - so someone 
verify, please.

Vern

On 11/3/2010 10:44 AM, Bryce Martin wrote:
> Are you on OS version 7.1?  The reason why I ask is that you can use
> embedded sql for processing stored procedures if you are on any release
> older than 7.1.   The datastructure issue is a whole different issue as
> addressed by Brigitta and Michael.
>
>
> Thanks
> Bryce Martin
> Programmer/Analyst I
> 570-546-4777
>
>
>
> Michael Ryan<michaelrtr@xxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 11/03/2010 10:01 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
> Re: Data Structure with Array in SQL Call Not Allowed?
>
> 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!