467,185 Members | 1,207 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,185 developers. It's quick & easy.

C Stored Procedure error SQL0444N

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
  • viewed: 2285
Share:
1 Reply
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.

Similar topics

1 post views Thread by Private Pyle | last post: by
reply views Thread by vaishaliekhar@yahoo.com | last post: by
3 posts views Thread by mdaetwyler@gmail.com | last post: by
5 posts views Thread by PJackson@txfb-ins.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.