Antw: syntax error 201

Posted in 2000

Martin Fey — Thu, 27 Jul 2000 11:55:16 +0200 — source: Informix-list mailing list archive (1991-1998)

Hello, try this: unload to 'subs_to_sn7' delimiter ' 'select "CreateSubscription 999 MSISDN=" || tele_no from subs_to_move_2607 where XX="aaaaaa" and TPLAN="001" and yy=40.00; I gess XX, TPLAN and yy are columns of the table ubs_to_move_2607!? Martin >>> <r.bertrand@libertel.nl> 27.07.00 08:50 >>> 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.