Re: SQL question on embedded varaibles

On Jun 25, 2023, at 8:14 AM, liam henderson <liamhenderson12@xxxxxxxxx> wrote:

Hi,
I'm trying to use a variable to list some values that I want to use on an
IN statement on my WHERE clause but don't seem to able to get it quite
right.
Interactive SQL returns a result but the program doesn't
It returns SQLSTATE='02000' SQLCODE=100

EXEC SQL
SELECT LOC INTO :wLOC
FROM LOCATION
WHERE LTYP NOT IN ('F','H','I','O','B') AND
SUBA IN (:wSUBA) AND
PALT = :wPALT

The string :wSUBA is formatted as 'AA ','AB ','AC ','AD ','AE'
I tried moving the brackets into the string but that didn't work
I also tried removing the quotes and just comma separating but that didn't
work
Is what I'm doing even possible or do I need to split them out and check
one by one?
I'm probably doing something really stupid.
Any help much appreciated.
Regards.
Liam.
--
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.