I am trying to download data from a read-only database using odbc load, exec().
My SQL query is generated from my existing data and saved into a local macro. It's about 400,000 characters long (there's a good reason for this, but it's not relevant to the question).
When I try to run odbc with it, I get the following error:
Code:
table() or exec() is required
r(198);
I played around with it a little, and for strings that are under 260K, the command runs without a problem, but over 320K it fails. I could narrow that number down more, but I didn't see much point to it.
It seems that the parser is not able to parse the entire input beyond a certain length and throws that error.
I can't find any memory/size limit that is being violated.
Does anyone have any solutions for this?
I'd rather try to "solve" this elegantly before resorting to some kludgy solution that breaks up the query and then appends the results back together...

Thank you in advance.