473,320 Members | 1,854 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,320 software developers and data experts.

SQL0444N when calling a stored procedure

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 running
SP's so I wrote a very simple procedure just to make sure everything
is working. Below is the db2set output for the
SQLROUTINE_COMPILE_COMMAND, stored procedure text, log file, and
result of a call. I'm getting an error that says function "pgsjmp"
cannot be accessed reason code 6. The message associated with that
reason code doesn't offer much help. The path to the compiler is in
/usr/vac/bin.

Can anyone tell me what "pgsjmp" is and what it's used for?

Any ideas are greatly appreciated.

db2set output:
DB2_SQLROUTINE_COMPILE_COMMAND=xlc_r
-I/home/brdinst0/sqllib/include/SQLROUTINE_FILENAME.c
-bE:SQLROUTINE_FILENAME.exp -e SQLROUTINE_ENTRY -o SQLROUTINE_FILENAME
-L/home/brdinst0/sqllib/lib -ldb2
Procedure text:
create procedure brdinst0.proc_time ( out var1 timestamp )
specific proc1
language sql
P1: BEGIN

values current timestamp into var1 ;

END P1

@

Log File output:
-- LOG FILE P2451252.log FOR PROCEDURE BRDINST0.PROC_TIME

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
/home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.sqc

LINE MESSAGES FOR P2451252.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

-- DB2_SQLROUTINE_COMPILE_COMMAND=xlc_r
-I/home/brdinst0/sqllib/include/SQLROUTINE_FILENAME.c
-bE:SQLROUTINE_FILENAME.exp -e SQLROUTINE_EN
TRY -o SQLROUTINE_FILENAME -L/home/brdinst0/sqllib/lib -ldb2

-- CONTENTS OF /home/brdinst0/sqllib/function/routine/sr_cpath

#!/bin/sh
PATH=$PATH:/usr/vac/bin
PATH=$PATH:/usr/vacpp/bin
PATH=$PATH:/usr/ibmcxx/bin
PATH=$PATH:/usr/lpp/xlC/bin
export PATH

-- CONTENTS OF /home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.sh

SQLROUTINE_FILENAME=P2451252
export SQLROUTINE_FILENAME
export SQLROUTINE_ENTRY=pgsjmp

-- COMPILATION COMMAND:

xlc_r -I/home/brdinst0/sqllib/include/P2451252.c -bE:P2451252.exp -e
pgsjmp -o P2451252 -L/home/brdinst0/sqllib/lib -ldb2
-- CONTENTS OF /home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.exp

pgsjmp
-- COMPILATION MESSAGES FOR
/home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.c
ld: 0711-327 WARNING: Entry point not found: pgsjmp
ld: 0711-319 WARNING: Exported symbol not defined: pgsjmp
ld: 0711-244 ERROR: No csects or exported symbols have been saved.

-- END OF LOG FILE (SQLCODE: 0)
Call Statement output:
db2 "call brdinst0.proc_time (?)"

SQL0444N Routine "PROC_TIME" (specific name "PROC1") is implemented
with code
in library or path ".../routine/sqlproc/BRDODS2/BRDINST0/P2451252",
function
"pgsjmp" which cannot be accessed. Reason code: "6". SQLSTATE=42724
Nov 12 '05 #1
1 7279
Private Pyle wrote:
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 running
SP's so I wrote a very simple procedure just to make sure everything
is working. Below is the db2set output for the
SQLROUTINE_COMPILE_COMMAND, stored procedure text, log file, and
result of a call. I'm getting an error that says function "pgsjmp"
cannot be accessed reason code 6. The message associated with that
reason code doesn't offer much help. The path to the compiler is in
/usr/vac/bin.

Can anyone tell me what "pgsjmp" is and what it's used for?

Any ideas are greatly appreciated.

db2set output:
DB2_SQLROUTINE_COMPILE_COMMAND=xlc_r
-I/home/brdinst0/sqllib/include/SQLROUTINE_FILENAME.c
-bE:SQLROUTINE_FILENAME.exp -e SQLROUTINE_ENTRY -o SQLROUTINE_FILENAME
-L/home/brdinst0/sqllib/lib -ldb2
Procedure text:
create procedure brdinst0.proc_time ( out var1 timestamp )
specific proc1
language sql
P1: BEGIN

values current timestamp into var1 ;

END P1

@

Log File output:
-- LOG FILE P2451252.log FOR PROCEDURE BRDINST0.PROC_TIME

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
/home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.sqc

LINE MESSAGES FOR P2451252.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

-- DB2_SQLROUTINE_COMPILE_COMMAND=xlc_r
-I/home/brdinst0/sqllib/include/SQLROUTINE_FILENAME.c
-bE:SQLROUTINE_FILENAME.exp -e SQLROUTINE_EN
TRY -o SQLROUTINE_FILENAME -L/home/brdinst0/sqllib/lib -ldb2

-- CONTENTS OF /home/brdinst0/sqllib/function/routine/sr_cpath

#!/bin/sh
PATH=$PATH:/usr/vac/bin
PATH=$PATH:/usr/vacpp/bin
PATH=$PATH:/usr/ibmcxx/bin
PATH=$PATH:/usr/lpp/xlC/bin
export PATH

-- CONTENTS OF /home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.sh

SQLROUTINE_FILENAME=P2451252
export SQLROUTINE_FILENAME
export SQLROUTINE_ENTRY=pgsjmp

-- COMPILATION COMMAND:

xlc_r -I/home/brdinst0/sqllib/include/P2451252.c -bE:P2451252.exp -e
pgsjmp -o P2451252 -L/home/brdinst0/sqllib/lib -ldb2
-- CONTENTS OF /home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.exp

pgsjmp
-- COMPILATION MESSAGES FOR
/home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.c
ld: 0711-327 WARNING: Entry point not found: pgsjmp
ld: 0711-319 WARNING: Exported symbol not defined: pgsjmp
ld: 0711-244 ERROR: No csects or exported symbols have been saved.

-- END OF LOG FILE (SQLCODE: 0)
Call Statement output:
db2 "call brdinst0.proc_time (?)"


SQL0444N Routine "PROC_TIME" (specific name "PROC1") is implemented
with code
in library or path ".../routine/sqlproc/BRDODS2/BRDINST0/P2451252",
function
"pgsjmp" which cannot be accessed. Reason code: "6". SQLSTATE=42724


pgsjmp is the entry point DB2 used for their SQL procedures. Take a look
at
/home/brdinst0/sqllib/function/routine/sqlproc/BRDODS2/BRDINST0/tmp/P2451252.c,
something must be screwed up in there.

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: dw | last post by:
Hello all, I'm having a dickens of a time calling a stored procedure on a connection. Every time I do, it generates an error "Arguments are of the wrong type, are out of acceptable range, or are in...
5
by: Warren Wright | last post by:
Hi group, I have a select statement that if run against a 1 million record database directly in query analyzer takes less than 1 second. However, if I execute the select statement in a stored...
1
by: Anthony Robinson | last post by:
I'm executing a stored procedure and getting the SQL0440N No authorized routine named "AMROBI2.CREATEAIMCONNECTION" of type "PROCEDURE " having compatible arguments was found. The schema...
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')@...
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...
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: Loop123 | last post by:
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 ...
2
by: Serman D. | last post by:
Hi all, I'm trying to complete the samples from the excellent 2003 developerWorks article "Bringing the Power of Regular Expression Matching to SQL" by Knut Stolze: http://tinyurl.com/3bhrnn...
11
by: peter | last post by:
I am trying to get a SQL stored procedure to use user maintained MQT implicitly which raises questions on when they are used or not used. In theory you would expect the stored procedure to pick up...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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: 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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.