Re: 4GL/Unload problem ..

Posted in 1998

Alex Dron — 24 Sep 1998 13:37:27 GMT — source: Informix-list mailing list archive (1991-1998)

SUNIL S. SINGH (sunil.singh@tatainfotech.com) wrote: : : H! .... : : In a 4gl program I write : : UNLOAD TO abc.unl SELECT * FROM tab_chmast : : It works fine, but my table name changes dynamically hence I rewrote : : LET sql_s = "UNLOAD TO abc.unl SELECT * FROM ", : variable_containing_table_name : PREPARE sql_str FROM sql_s : EXECUTE sql_str You cannot prepare unload statement in 4GL. But you can instead use string variable for select clause: LET vv = "select * from ",var_tab_name UNLOAD TO abc.unl vv : TIA : Sunil : -- Dron Alexander, IDS