RE: SQL Result Sets

[CWilt@xxxxxxxxxxxx]

Do you have the DYNAMIC RESULTS SETS 2 specified on the create procedure
statement?

CREATE PROCEDURE ASSEMBLY_PARTS (IN ASSEMBLY_NUM INTEGER,
OUT NUM_PARTS INTEGER,
OUT COST DOUBLE)
LANGUAGE C
PARAMETER STYLE GENERAL
DYNAMIC RESULT SETS 2
FENCED
EXTERNAL NAME ASSEMBLY

HTH,
Charles



> -----Original Message-----
> From: Dave Boettcher [mailto:DBoettch@xxxxxxxxxxxxxxxx]
> Sent: Tuesday, February 24, 2004 3:23 PM
> To: rpg400-l@xxxxxxxxxxxx; RPGIV@xxxxxxxxxxxxxxx
> Subject: SQL Result Sets
> 
> 
> Perhaps someone out there knows how we can do this.  Thanks in advance
> for the help.
> We have searched GOOGLE and the archives on the Midrange and RPGIV
> sites.  The question appears a few times all the way back to 1998, but
> we have not seen an answer posted even though several posts said they
> might  try it out.  :>)
>  
> We want to return two result sets from an RPGIV program.  
> We get only the last one back to the calling PHP program.
> the RPGIV SQL code to return the result sets is below:
> 
>  c/exec SQL                                             
>  c+  Set Result Sets Array :TaxDta for :TaxNdx rows     
>  c/end-exec                                             
>                                                         
>  c/exec SQL                                             
>  c+  Set Result Sets Array :AssmtDta for :AssmtNdx rows 
>  c/end-exec                                             
>                                                         
> Does anyone know if this should work?  OR do you know of 
> another way to
> accomplish the same thing.
>  
> Any response is appreciated, especially "yes" or "it will never work
> and here's why"
>  
> TIA, 
>  
> Dave Boettcher
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (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.
>