RE: 4GL/Unload problem ..
Check the manual. You cannot use unload in a prepared statement. See the
Prepare entry in the 4GL reference manual.
Jon
> -----Original Message-----
> From: SUNIL S. SINGH [SMTP:sunil.singh@tatainfotech.com]
> Sent: 24 September 1998 09:23
> To: informix list
> Subject: 4GL/Unload problem ..
>
> 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
>
> It gives run time error -201 (syntax error)
>
> Any Ideas...
>
> TIA
> Sunil
>
> -----------------------<sunil.singh@tatainfotech.com>-----------------
> --------
> . .
> . .
> . .
> . .
> . *
> . TATA INFOTECH LTD.
> . SEEPZ,
> . Andheri (E),
> SUNIL S. SINGH Mumbai - 400 096,
> (Sr. Software Engineer) India.
> ----------------------------------------------------------------------
> --------