Re: 4GL/Unload problem ..
Hi there,
You cannot prepare an "unload" statement, that's why you have a syntax error
(-201) ...
SUNIL S. SINGH 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
>
> 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.
> ------------------------------------------------------------------------------