Re: illegal character error with INSERT statement and &BIND

maroof_ahmed@peoplesoft.com wrote: > > Why do I get Informix error [-202] "An illegal character" at pos 00013 in the > following INSERT line: > > INSERT INTO &BIND ( > TAO_GROUP,NOQUOTES) > > Is it because I have an empty space between &BIND and the left parenthesis? Or > I have a carriage return after the left parenthesis? Or both? Neither. It is because ampersand (&) is not a legal character in a table name in Informix. Do you really have a table named "&Bind"? or is that part of some front end access tool you are trying to use? You do not specify how you are trying to run this insert. Using dbaccess? Using DBD/Informix? 4GL? ESQL/C? CLI/C? MS-Access? How? Art S. Kagel