How to save a list of programs

Hi all,

I have a list of programs which is generated by a 3rd party software application. This is in the form of ('program1', 'program2', 'program3'). The list is actually used in a WHERE IN ('program1', 'program2', 'program3') sql statement used by the vendor software.

Basically I want to use that same WHERE IN ('program1', 'program2', 'program3') statement within a custom RPG program. I'm planning to PREPARE an sql CURSOR and add the WHERE IN (:myprogramList).

But I can't figure out how to save the list as one big string. Does anyone know how I can save ('program1', 'program2', 'program3') as one big string?

The problem I'm experiencing (I think) is that the quotes are interpreted as string delimiters. I was trying with a data area and a one column table but both had the same issue. Any ideas?

Thanks,

Rob