delete from

Posted in 2000

Andreas Lommel — Thu, 30 Mar 2000 08:01:11 GMT — source: Informix-list mailing list archive (1991-1998)

Hi there, maybe someone can help me: Script in unix: echo "delete * from (fa_daten) WHERE (fa_nr Not Like"E%")"|dbaccess dbasename error message: Database selected. 201: A syntax error has occurred. Error in line 1Near character position 8 Database closed. What`s wrong ???

↪ replying to Andreas Lommel

David Williams — Fri, 31 Mar 2000 00:03:42 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <38e30909.912992@news.btx.dtag.de>, Andreas Lommel <him_lommel@t-online.de> writes >Hi there, maybe someone can help me: >Script in unix: >echo "delete * from (fa_daten) WHERE (fa_nr Not Like"E%")"|dbaccess ^ ^ ^ ^ ^ first " treated as the end of the string being send to dbaccess!! echo 'delete from fa_daten WHERE (fa_nr NOT LIKE "E*" )' | dbaccess dbasename >dbasename >error message: >Database selected. > 201: A syntax error has occurred. >Error in line 1>Near character position 8 >Database closed. > >What`s wrong ??? -- David Williams

Glossary

dbaccess