DPF环境对触发器使用call语句的支持?

V11在DPF环境下能否支持在触发器,函数里使用call语句,目前V10.5版本并不支持。

参与12

3同行回答

iXJJiXJJ软件开发工程师泰康
请能具体提供上述产品在V10.5里面的限制相关的信息么?目前我在10.5和11的knowledge center里均未见到相关限制。显示全部

请能具体提供上述产品在V10.5里面的限制相关的信息么?

目前我在10.5和11的knowledge center里均未见到相关限制。

收起
软件开发 · 2016-08-30
浏览1610
  • DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0270N Function not supported (Reason code = "113"). LINE NUMBER=1. SQLSTATE=42997 你可以尝试在DPF环境下建个触发器调用存储过程,就会报以上错误信息。 查对应的错误信息,其中就有说明在分区数据库环境下,不能在触发器使用call语句
    2016-09-01
iXJJiXJJ软件开发工程师泰康
I think I got your points ...basically, the error you referred as SQL0270N, ReasonCode=113 is due to you use compound SQL (compiled) in your trigger definition. Error code Explanation:         Use of a Compound SQL (comp...显示全部

I think I got your points ...

basically, the error you referred as SQL0270N, ReasonCode=113 is due to you use compound SQL (compiled) in your trigger definition.

Error code Explanation:

         Use of a Compound SQL (compiled) statement in the body of a

         trigger is not supported in partitioned database environments.

         Prior to DB2 Version 9.7 Fix Pack 1, use of a Compound SQL

         (compiled) statement as an SQL function body is not supported

         in partitioned database environments.

User response for 113

         If possible, define the trigger using a compound SQL (inlined)

         statement, or remove the trigger definition. For DB2 Version

         9.7 prior to Fix Pack 1, define the function or trigger using a

         compound SQL (inlined) statement, or remove the function or

         trigger definition.         



And yes, it's not support in both 10.5 and 11 with the statement of " A compound SQL (compiled) statement also cannot be specified for a trigger definition in a partitioned database environment. "   in DB2 Knowledge Center

链接文字 http://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000931.html

收起
软件开发 · 2016-09-02
浏览1506
  • 所以,在DPF里,如果一个触发器里需要多次调用不同的存储过程,目前就只能贴存储过程的代码进去, 不过这很麻烦
    2016-09-02
iXJJiXJJ软件开发工程师泰康
方便提供您的trigger编写及相应db2diag.log分析么?显示全部

方便提供您的trigger编写及相应db2diag.log分析么?

收起
软件开发 · 2016-09-02
浏览1507

提问者

liaogzhu
数据库开发工程师PCI

问题来自

  • 相关问题

    相关资料

    相关文章

    问题状态

  • 发布时间:2016-08-26
  • 关注会员:2 人
  • 问题浏览:4985
  • 最近回答:2016-09-02
  • X社区推广