RE: Antw: syntax error 201

Hello, The problem has allready been solved; this is the correct statement: unload to 'subs_to_sn7' delimiter ' 'select "CreateSubscription 999 MSISDN=" || tele_no || " XX=aaaaaa TPLAN=001 yy=40.00" from subs_to_move_2607 Thanks a lot four your help ! -----Original Message----- From: Martin Fey [mailto:Martin.Fey@bluvo.de] Sent: Thursday, July 27, 2000 11:55 To: informix-list@iiug.org; r.bertrand@libertel.nl Subject: Antw: syntax error 201 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.