当前位置:首页>维修大全>综合>

DB2中查询语句超过了表限制怎么办(怎么查看db2的建表语句)

DB2中查询语句超过了表限制怎么办(怎么查看db2的建表语句)

更新时间:2024-08-06 00:24:13

DB2中查询语句超过了表限制怎么办

语句太长、太复杂,超出了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

更多栏目