RE: SQL Result Sets

Rob,

May be hard to believe, but the standard iSeries DB2 manuals.

I keep PDF versions of:
SQL Reference
SQL Programming Concepts
SQL Programming with Host Languages

and just added the Redbook (mentioned in a post here)
Stored Procedures, Triggers, and UDF on DB2 UDB for iSeries.

I hit them often for my own questions. Luckily, I have a pretty good recall
for stuff that I simply read on the way to my own answers.

In this case, I remembered seeing  the "dynamic results sets xx"  clause
during the many times I've looked at stored procedures.  Wasn't a big deal
to open the PDF and copy-paste the example.


HTH,
Charles


> -----Original Message-----
> From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
> Sent: Tuesday, February 24, 2004 5:02 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL Result Sets
> 
> 
> I have to ask:  How did you figure that one out?
> - Some DB class in college?
> - Experience from other databases?
> - Standard DB2 iseries manuals?
> - Third party book on DB2 on the iSeries?
> - Someone else's code at your site?
> - This list?
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> CWilt@xxxxxxxxxxxx 
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 02/24/2004 04:55 PM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> 
> 
> To
> rpg400-l@xxxxxxxxxxxx
> cc
> 
> Fax to
> 
> Subject
> RE: SQL Result Sets
> 
> 
> 
> 
> 
> 
> 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.
> > 
> _______________________________________________
> 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.
> 
> 
> _______________________________________________
> 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.
>