Hi,
I am trying to run an unload statement which is about 10000 lines long. I get an error which states that "Statement length too long"
Any workarounds?
This is on a HP-UX box
Thanks in anticipation

can you do the same think via the script and pipe the statments into dbaccess?

Can you provide the examples of a few lines?

Hi,

Probably I am not understanding it correctly, but do you really mean 1 statement. Or a lot of statements. I believe the maximum statementsize is limited to 64 KB. So if it is really one statement is looks really to big.

Of the record: I can not really imagine what type of query I need to write to fill it up with 100000 lines. Only possibility is to have a major IN clause. Of course this can be avoided to firts insert the values in a (temp) table.

Hope this helps,

Rob