环境 aix5.3.06 、gcc v4.2.0、9.5DB2 v9.5.0.0", "s071001", "AIX6495", and Fix Pack "0". 64位数据库;编译的时候SQC的时候报: 4722 SQL0440N No authorized routine named "SUBSTR" of type &nb...
显示全部环境 aix5.3.06 、gcc v4.2.0、9.5DB2 v9.5.0.0", "s071001", "AIX6495", and Fix Pack "0". 64位数据库;
编译的时候SQC的时候报:
4722 SQL0440N No authorized routine named "SUBSTR" of type
"FUNCTION" having compatible arguments was found.
SQLSTATE=42884
8375 SQL0440N No authorized routine named "SUBSTR" of type
"FUNCTION" having compatible arguments was found.
SQLSTATE=42884
其中语句的条件为:
AND SUBSTR(BANK_ACC_NO,:m_bank_acc_pos,:m_bank_acc_len)=SUBSTR(:m_bank_acc,1,:m_bank_acc_len) ,字符型字段
但在命令行下,使用select语句可以使用substr函数,在syscat.funcations 中没有substr函数。
请指点下,谢谢!
收起