语句太长、太复杂,超出了DB2的限制,重新SQL语句吧。
建立临时表,把数据放入临时表中。
db2 => ? sql101
SQL0101N The statement is too long or too complex.
Explanation:
The statement could not be processed because it exceeds a system limit
for either length or complexity, or because too many constraints or
triggers are involved.
If the statement is one that creates or modifies a packed description,
the new packed description may be too large for its corresponding column
in the system catalogs.
Federated system users should also check to see if the statement:
* Exceeds either a federated server system limit or a data source
system limit for length or complexity.
* Violates some other data source specific limit.
The statement cannot be processed.
Note: Where character data conversions are performed for applications
and databases running under different codepages, the result of the
conversion is exceeding the length limit.
User response:
Either:
* Break the statement up into shorter or less complex SQL statements.
* Incr