回覆列表
  • 1 # 陽光魯寧

    語句太長、太複雜,超出了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

  • 中秋節和大豐收的關聯?
  • 太陽系內是否還有“塵埃雲”形式的“偽衛星”在繞著地球運轉?