syntax error 201

Posted in 2000

Topics: SQL Development & Query Writing, Migration, Import/Export & Data Conversion

r.bertrand@libertel.nl — Thu, 27 Jul 2000 06:50:07 GMT — source: Informix-list mailing list archive (1991-1998)

Hello , I'm trying to run a quiet simple select statement but i always get a syntax error; i haven been trying to fix it now for a couple of hours but i can not figure out what the syntax error os then ? Can anyone help me out ? Thanks in advance ! Ruud This is the statement: unload to 'subs_to_sn7' delimiter ' 'select "CreateSubscription 999 MSISDN=" || tele_no from subs_to_move_2607 || " XX=aaaaaa TPLAN=001 yy=40.00" Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to r.bertrand@libertel.nl

Frido van Orden — Thu, 27 Jul 2000 09:58:42 +0200 — source: Informix-list mailing list archive (1991-1998)

unload to 'subs_to_sn7' delimiter ' 'select "CreateSubscription 999 MSISDN=" || tele_no || " XX=aaaaaa TPLAN=001 yy=40.00 from subs_to_move_2607 <r.bertrand@libertel.nl> schreef in berichtnieuws 8lom2v$v2j$1@nnrp1.deja.com... > Hello , > > I'm trying to run a quiet simple select statement but i always get a > syntax error; i haven been trying to fix it now for a couple of hours but i > can not figure out what the syntax error os then ? Can anyone help me > out ? > Thanks in advance ! > > Ruud > > This is the statement: > > unload to 'subs_to_sn7' delimiter ' '> select "CreateSubscription 999 MSISDN=" || tele_no from > subs_to_move_2607 || > " XX=aaaaaa TPLAN=001 yy=40.00" > > > Sent via Deja.com http://www.deja.com/ > Before you buy.