By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,287 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

C Stored Procedure error SQL0444N

P: n/a
Greetings,

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....

Regards

Yogesh Kansal

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.