I have an issue with a Query Manager where I need help with the syntax for a list of entries in the Select not in ( ) portion.
I have a command that will call an RPGLE module which will call the Query Manager. I know that the quotes have to be supplied by the calling program (found a lot of info in the other Tech articles that helped with this). But I am having trouble with this one.
From the RPG, I have variables for the quote = Q and the info in the () for the select statement.
EVAL Q = ''''
IF EXCLUDE <> *BLANKS
EVAL EXCLUDES = '('
FOR X = 1 TO 6
IF EXC(X) <> ' '
EVAL EXCLUDES = EXCLUDES + ',' +
Q + EXC(X) + Q
EVAL EXCLUDES = %TRIM(EXCLUDES) + ')
iSeries V5R2, STRQMQRY
November 20, 2010 9:43 PM
November 29, 2010 7:36 AM