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.
------------------------------------------------------------------------------