SQL0444N when calling a stored procedure

Private Pyle

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_COMP ILE_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_FILE NAME.c
-bE:SQLROUTINE_F ILENAME.exp -e SQLROUTINE_ENTR Y -o SQLROUTINE_FILE NAME
-L/home/brdinst0/sqllib/lib -ldb2
Procedure text:
create procedure brdinst0.proc_t ime ( 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_T IME

-- 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_FILE NAME.c
-bE:SQLROUTINE_F ILENAME.exp -e SQLROUTINE_EN
TRY -o SQLROUTINE_FILE NAME -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_FILE NAME=P2451252
export SQLROUTINE_FILE NAME
export SQLROUTINE_ENTR Y=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_t ime (?)"

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

Subscribe Reply

7342

W Gemini

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_COMP ILE_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_FILE NAME.c
-bE:SQLROUTINE_F ILENAME.exp -e SQLROUTINE_ENTR Y -o SQLROUTINE_FILE NAME
-L/home/brdinst0/sqllib/lib -ldb2
Procedure text:
create procedure brdinst0.proc_t ime ( 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_T IME

-- 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_FILE NAME.c
-bE:SQLROUTINE_F ILENAME.exp -e SQLROUTINE_EN
TRY -o SQLROUTINE_FILE NAME -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_FILE NAME=P2451252
export SQLROUTINE_FILE NAME
export SQLROUTINE_ENTR Y=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_t ime (?)"

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

Similar topics

6896

Calling stored procedure on connection

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 conflict with one another." I've run the same stored procedure with the same exact list of arguments in Query Analyser in SQL Server, and it works. The page has the adovbs constants. Note that uspGetProperties is a stored procedure in SQL...

ASP / Active Server Pages

7281

Diff. performance in Query Analyzer than when using stored procedure

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 procedure instead, calling the stored proc from query analyzer, then it takes 12-17 seconds. Here is what I execute in Query Analyzer when bypassing the stored procedure:

Microsoft SQL Server

30722

Calling Stored Procedures

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 exists, the stored procedure exists, the user executing the procedure has execute permissions on the procedure and also has insert, update, delete rights on the table being accessed in the stored procedure. I'm sending in the correct number of input...

DB2 Database

2494

C Stored Procedure error SQL0444N

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')@ SQL0444N Routine "TRUNCATE" (specific name "TRUNCATE_TABLE") is implemented with code in library or path ".../sqllib/function/functions", function

DB2 Database

32091

SQL0444N Reason Code 4 SQLSTATE=42724

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 Server 2003. I created the stored procedure on the DB2 server. When I call the sp from within my VB code, it uses a DSN to connect to the database. The DSN uses the IBM DB2 ODBC Driver. I get the following error message: Error: SQL0444N...

DB2 Database

1331

SQL0444N Code 6 when calling STORED PROCEDURE

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 "xxx" (specific name "xxx") is implemented with code in library or path "\xxx", function "xxx" which cannot be accessed. Reason code: "6". SQLSTATE=42724. I read a lot about that, but i can't find the error...can anybody help me??? The stored...

DB2 Database

1770

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

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

DB2 Database

5706

UDF call to C wrapper for PCRE library fails - SQL0444N, Reason code: "5", SQLSTATE=42724

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 I've managed to compile and link the C code from "Listing 5", the regexpSimple() wrapper (see link). The build options are pretty much

DB2 Database

3420

When does a stored procedure use an MQT

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 the MQT at the time it is bound on the creation of the static SQL. This raises the question on how you stop it or start it using a MQT as there is no option on the bind. What happens when it is rebound? What happens if the plan is made invalid...

DB2 Database

8465

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8894

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8803

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8587

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7407

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4206

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4384

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2792

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2029

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP