RE: select into in logic

CCTYPE is character? If so, the most common problem is punctuation.
Remember ... IN ('A', 'B', 'C') is the proper format. Check your
parenthesis, quotes, and commas.

Steve

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
iseriesstuff
Sent: Saturday, November 7, 2020 08:50
To: Midrange <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: select into in logic

i have the following code. when i pass a single value for the "in"
clause it works, when i try multi it doesnt.

exec sql SELECT sum( AMOUNT ) into :rtnvar FROM revsprp2 WHERE CCTYPE in
:cctypein and STS = ' ';

any ideas?

--
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.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com