RE: PREPARE SEL FROM -206 error

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

I think the problem is the double quotes.  I may be wrong, but I'm pretty
sure that SQL prefers single quotes.  So when you need a literal (the letter
'R'), you need to enclose it in single quotes.  But since you are in a
quoted string, you need DOUBLE single quotes ('') which are different from
double quotes (").  This:

> D                                     WHERE SUBSTR(FIL44,43,1)="R" -

Changes to:

> D                                     WHERE SUBSTR(FIL44,43,1)=''R'' -

Joe


> From: mcrangle@xxxxxxxxxxxxxxxxxxxx
>
> I thought this would work, as there is no syntax error using double quotes
>
> D SelectOne       S            500A   INZ('SELECT ITNBR, ITDSC,  -
> D                                     ITTYP -
> D                                     FROM AMFLIB/ITEMASA  -
> D                                     WHERE SUBSTR(FIL44,43,1)="R" -
> D                                     ORDER BY')