Re: PREPARE SEL FROM -206 error

Martin,

 Error 206 is: Column &1 not in specified tables.

 The reason for that is because specifying double quotes makes SQL think
that whatever is between them is a VARIABLE!  Since you don't have a
variable called R in your table you are getting the error.

 -mark

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')

But no records are selected on the OPEN MYCSR, but when I comment the
substr D spec, it retrieves ALL records.

I've searched midrange and seen some use of the CAT command, but not as a
solution.

Regards

Martin Crangle, MCMI
MIS Technician
IBM Certified RPGIV Programmer.
Cinetic Landis Grinding Ltd.
Tel: + 44(0) 1535 633211
Fax: + 44(0) 1535 639572

Crosshills, Keighley, West Yorkshire, BD20 7SD (England)