Re: Select into with Case

Oh. My. God.

I'll go back in hiding now.

I guess it needed a different set of eyes.

Thank you.


On Wed, Apr 9, 2025 at 11:09 AM mlazarus <mlazarus@xxxxxxxxxxxx> wrote:

Jeff,

Try preceding the CWTCD with a colon, as :CWTCD.

-mark

On 4/9/2025 11:04 AM, Jeff Crosby wrote:

Is this statement valid:

Exec SQL
Select Coalesce(Sum(RHQYRC),0),
Case CWTCD
When ItmIsCwt Then Coalesce(Sum(RHCOST*RHWRTC),0)
Else Coalesce(Sum(RHCOST*RHQYRC),0)
End
Into :VQYRC,
:VCOST
From DMRECHST
Where RHITEM = :ITNBR and
RHDTRC>= :WkBegDat and
RHDTRC<= :WkEndDat;

The RPG compiler is yelling at me saying "SQL0206: Position 26 Column or
global variable CWTCD not found."

Variable CWTCD is a field in a file in the program that is NOT being
processed via SQL.

Thanks.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.