- 论坛徽章:
- 0
|
编译了一下楼主的程序,在UNIX下确实能编译并运行.
但是我想用它变成DB2的一个自定义函数时,老是出问题:
values TrimChr(' aaaa ');
[IBM][CLI Driver][DB2/LINUX] SQL0444N Routine "TRIMCHR" (specific name "SQL080529112348600") is implemented with code in library or path ".../sqllib/function/TrimChr", function "TrimChr" which cannot be accessed. Reason code: "5". SQLSTATE=42724
自定义函数是如此写的:
CREATE FUNCTION TrimChr (VARCHAR(400))
RETURNS VARCHAR(400)
EXTERNAL NAME '/home/db2inst1/sqllib/function/TrimChr!TrimChr'
LANGUAGE C
NULL CALL
PARAMETER STYLE DB2SQL
NO SQL
DETERMINISTIC
NO EXTERNAL ACTION
NOT FENCED;
GRANT EXECUTE ON FUNCTION TRIMCHR(VARCHAR(400)) TO PUBLIC; |
|