Re: 4GL/Unload problem ..

Wu wrote: > > Hi there, > > You cannot prepare an "unload" statement, that's why you have a syntax error > (-201) ... Just to be clear. The reason you cannot prepare an UNLOAD statement is that it is not a SQL statement it is a 4GL builtin command which was included to support the same syntax as the UNLOAD built into dbaccess. > 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)