Using DB2 9.7 fixpack 4 on Windows 7.
I have a situation where I am creating a huge SQL inline query into a 32k VARCHAR. The SQL query string I am generating is so large that apparently the string is cut-off before it has been fully constructed
I then execute the SQL query string using:
PREPARE S1 FROM V_SQL;
Are there alternative ways to create a query string? A 32k VARCHAR does not seem to be enough for me. The query has to be executed in one go though...