yogesh wrote:
I have written a C language Stored Procedure on DB2 UDB V8 on solaris.
While execting the SP i am gettign the following the error :
db2 => call truncate ('BUSINESS','ACCT')@
SQL0444N Routine "TRUNCATE" (specific name "TRUNCATE_TABLE") is
implemented
with code in library or path ".../sqllib/function/functions", function
"truncate_table" which cannot be accessed. Reason code: "5".
SQLSTATE=42724
There is enough mem available for the instance. File 'functions' also
exist in ~/sqllib/function dir.
$ ls -l /export/home/ti1u8s8/sqllib/function/functions
-rwxr-xr-x 1 ti1u8s8 db2grp1 9532 Jul 28 01:53
/export/home/ti1u8s8/sqllib/function/functions
Any pointers will be highly helpful....
What does the code look like and how did you compile it?
--
Knut Stolze
Information Integration
IBM Germany / University of Jena