Re: ESQL/C EXECUTE IMMEDIATE BUG?

Michael Mstowski (msm@spaceworks.com) wrote: : I'm having a problem using EXECUTE IMMEDIATE on the following : statement: : LOAD FROM "data" INSERT INTO mytabname You cannot EXECUTE IMMEDIATE the LOAD or UNLOAD commands because they are not server commands, they are executed by the client process. However, I seem to remember that the INSERT portion of the LOAD statement can be replaced with a character variable containing the text of the insert statement. The ESQL libraries probably use this string to prepare/ declare an insert cursor. : It does not work from within ESQL/C. : DELETE and other statements work, but I get a -201 syntax error, : but there is NO syntax error to be found. : Any help here is appreciated. : Thanks : Michael Mstowski : msm@spaceworks.com -Jeff