Re: HOW TO PREPARE A LOAD STATEMENT

dilip kumar biswal (dil@psi.ernet.in) wrote: : ATTEMPT : : PREPARE load_stmt FROM "LOAD FROM ? INSERT INTO ?" : RESULT : : Error no 201 encountered. : The mannual also says that it is impossible to prepare a LOAD stmt. That's true. But you can pass a string to the LOAD statement: LET s = "select * from some_table" UNLOAD TO "regular.file" s and the string gets prepared for you. But there is still no way to use positional parameters. You have to assign values into the query string itself. -- Jeff Sturm ZenaComp Incorporated jsturm@zenacomp.com