Hi,
Im trying to execute a C Stored Procedure(getTransactionId.sqc) from one of Developer Works articles "Transaction IDs in DB2 -- retrieve a unique identifier for a unit of work from the DB2 log records" by Knut Stolze and Im getting the following error upon issueing the command "db2 => CALL getTransactionId(?)"
.................................................. ...................
SQL0444N Routine "*ACTIONID" (specific name "GETTRANSACTIONID") is
implemented with code in library or path "...\getTransactionId.DLL", function
"getTransactionId" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
.................................................. ................
The dll file("getTransactionId.dll" is there under FUNCTION subdirectory). The contents of the script "getTransaction.db2" that is used for stored procedure registration with the database are as follows:
.................................................. ..........
CREATE PROCEDURE getTransactionId ( OUT transactionId CHAR(12) )
SPECIFIC getTransactionId
DYNAMIC RESULT SETS 0
MODIFIES SQL DATA
NOT DETERMINISTIC
NEW SAVEPOINT LEVEL
LANGUAGE C
EXTERNAL NAME 'D:\Programs\IBM\SQLLIB\FUNCTION\getTransactionId! getTransactionId'
FENCED THREADSAFE
NO EXTERNAL ACTION
PARAMETER STYLE SQL
PROGRAM TYPE SUB
NO DBINFO@
.................................................. .........
and the contents of the getTranactionId.def file are as follows (I created this file manually):
.................................................. .........
; getTransactionId.def : Declares the module parameters for the DLL.
LIBRARY "getTransactionId"
EXPORTS
getTransactionId
; Explicit exports can go here
.................................................. ..........
I've tried various ways but haven't been able to get to the root of the problem. I applied FixPak 14 as well but the problem is still there.
I've posted my query so many times on "developer works" but no one has replied yet.
Please help me. Its urgent.
Actually, the whole idea is to read DB2 Log files using db2api. If anyone has any idea about this, please help.
Thanks for any help.