LOAD statement IN a variable (for Incremental Loads)
Hi Everyone,
I've got a good system down for doing incremental loads, but the code overhead is fairly significant. Now, I'm required to build out dozens-to-hundreds of instances of incrementally-loaded tables, so would like to parameterize the loads somehow -- to make the whole process more dynamic. (Also my data source wouldn't allow "SELECT *", even if I resorted to that, so the field calls vary wildly.)
While the rest of my incremental code is functionally dynamic, based just on the table name, I only get script failure when I try putting the LOAD statement into a variable, and calling the variable at the appropriate point in the incremental load code.
Is there any trick to running this?
I suppose I could put the rest of the Incremental code in "before" and "after" Include files, so the only code on the page is the LOAD statement (ultimately this will all be in includes), but would prefer to keep everything in the script for now, at least until it's running right.
