Theo Kouwenhoven
asked on
SQLRPG Where IN(xxx) issue
Hi Experts,
I try to check a value in a SQL where clause, but get the error: CPD4374
On the Where xxxx in() of the next statement
Exec SQL Select * from my file
Where Field1 = :Parm1
and Field2 = in(:Parm2)
Field2 is numeric(15,0)
Parm2 is Character(128) and contains '12,13,45,16,32 '
What is missing?
I try to check a value in a SQL where clause, but get the error: CPD4374
On the Where xxxx in() of the next statement
Exec SQL Select * from my file
Where Field1 = :Parm1
and Field2 = in(:Parm2)
Field2 is numeric(15,0)
Parm2 is Character(128) and contains '12,13,45,16,32 '
What is missing?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I know that Dynamic will work and although my SQL knowledge is on a certain level,
I had hope that I missed some "TranslateStringToTable" like function.
Thanks for your quick response