473,322 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Stored Procedure!! SQL0444n Reason 4!!Is this normal.....

Hello,

i wrote a stored procedure, which ends with the command:
DB20000I The SQL command completed successfully.
But when i call the stored procedure i got the following error:
SQL0444N Routine "DB" (specific name "DB") is implemented
with code in library or path "\test", function "DB" which cannot be accessed. Reason code: "4". SQLSTATE=42724

Can anybody help me....? I knwo what reason code 4 is, but i can't find the error!!

THX
Jan 26 '07 #1
0 1757

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Private Pyle | last post by:
DB2 version 8, fixpack 5. Aix 5.1.0.0 Using C for AIX compiler. I'm having a problem where I can create stored procedures but I'm getting -444 when I call them. It's a new environment for...
1
by: yogesh | last post by:
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')@...
0
by: vaishaliekhar | last post by:
Hello, I have created a stored procedure using SPUFI. The stored procedure is defined to execute an external Assembler routine. There was no error while creating the stored procedure. While...
1
by: GarthVader | last post by:
I'm new to DB2 and am trying to execute a parameterized stored procedure from within a VB 6.0 application. We're using DB2 WSE version 8.2 with fixpack 10 running on a Windows Small Business...
2
by: Tonkuma | last post by:
I called Stored Procedure written in SQL from Object REXX on Windows like this CALL SQLEXEC 'CALL MigrateDECODE(:inString,:Converted)' CALL CHECKERR 'CALL MigrateDECODE' (CHECKERR was copied from...
0
by: Loop123 | last post by:
Hello @all, i have a problem....i wrote a stored procedure which ends with the command "complete successfully", but when i will call the stored procedure i got the message: SQL0444N Routine...
0
by: db2readlog | last post by:
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...
1
by: AngelaA | last post by:
The syntax to access a table is Select .. . How do I make the DatabaseName a variable – ideally to be passed as a parameter into the stored procedure? The reason being my test database uses a...
0
by: Dan Pichler | last post by:
I have done several hours of online research for help on this error and have had zero luck. I am hoping that someone can help. I have a simple stored procedure that compiles clean, but gets a...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.