Re: code for multiple INTO variables.

Select
sum(TAOOQ1) as CurrCount,
sum(TAOOQ2) as bucket1,
sum(TAOOQ3) as bucket2,
sum(TAOOQ4) as bucket3,
sum(TAOOQ5) as bucket4,
sum(TAOOQ6) as bucket5
INTO :CurrCount,
:bucket1,
:bucket2,
:bucket3,
:bucket4,
:bucket5
From XYZib/TAOPF
where TAYR = 2010

HTH,
Charles

On Fri, Nov 19, 2010 at 2:59 PM, Gqcy <gmufasa01@xxxxxxxxx> wrote:

I have the following statement that works in SQL:
Select sum(TAOOQ1) as CurrCount ,
    sum(TAOOQ2) as bucket1,
    sum(TAOOQ3) as bucket2,
    sum(TAOOQ4) as bucket3,
    sum(TAOOQ5) as bucket4,
    sum(TAOOQ6) as bucket5
    From XYZib/TAOPF
    where  TAYR = 2010

how do I code this in SQLRPG?

I tried to use "INTO :CurrCount", but it appears I can only use one per
statement.

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.