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!