Hi all
I am trying to call a DB/2 v8.2 stored procedure from Perl DBI and am
getting an error message telling me, that the routine could not be
found in the library path.
[IBM][CLI Driver][DB2/NT] SQL0444N Routine "*_deposit" (specific name
"SQL05051919014 8810") is implemented with code in library or path
"\finban.cac_de posit", function "finban.cac_dep osit" which cannot be
accessed. Reason code: "4". SQLSTATE=42724
Since 8.2 stores stored procedures internaly as byte code, the libaries
can indeed not be found in sqllib/FUNCTION/ROUTINE.
I tried to grant EXECUTE rights to all users on the packages found in
syscat.packages but this changed nothing.
Im am working with v8.2. on Windows, ActivePerl 5.61(638) and DBD-DB2
0.76 and DBI 1.34.
Cheers
Marc 3 2104 md********@gmai l.com wrote: Hi all I am trying to call a DB/2 v8.2 stored procedure from Perl DBI and am getting an error message telling me, that the routine could not be found in the library path.
[IBM][CLI Driver][DB2/NT] SQL0444N Routine "*_deposit" (specific name "SQL05051919014 8810") is implemented with code in library or path "\finban.cac_de posit", function "finban.cac_dep osit" which cannot be accessed. Reason code: "4". SQLSTATE=42724
Since 8.2 stores stored procedures internaly as byte code, the libaries can indeed not be found in sqllib/FUNCTION/ROUTINE.
I tried to grant EXECUTE rights to all users on the packages found in syscat.packages but this changed nothing.
Im am working with v8.2. on Windows, ActivePerl 5.61(638) and DBD-DB2 0.76 and DBI 1.34.
The problem you have is independent of PERL.
Now in V8.2 SQL Procedures which are CREATEd in V8.2 ar eall internal.
But external (java, C, ..) procedures or SQL Procedures created prior to
V8.2 still have DLLs.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Serge Rielau wrote: md********@gmai l.com wrote: Hi all I am trying to call a DB/2 v8.2 stored procedure from Perl DBI and am getting an error message telling me, that the routine could not be found in the library path.
[IBM][CLI Driver][DB2/NT] SQL0444N Routine "*_deposit" (specific name "SQL05051919014 8810") is implemented with code in library or path "\finban.cac_de posit", function "finban.cac_dep osit" which cannot be accessed. Reason code: "4". SQLSTATE=42724
Since 8.2 stores stored procedures internaly as byte code, the libaries can indeed not be found in sqllib/FUNCTION/ROUTINE.
I tried to grant EXECUTE rights to all users on the packages found in syscat.packages but this changed nothing.
Im am working with v8.2. on Windows, ActivePerl 5.61(638) and DBD-DB2 0.76 and DBI 1.34. The problem you have is independent of PERL. Now in V8.2 SQL Procedures which are CREATEd in V8.2 ar eall internal. But external (java, C, ..) procedures or SQL Procedures created prior to V8.2 still have DLLs.
Cheers Serge
To add to what Serge says, we got exactly the same problem with SPs being
called from VB after we migrated from V8.1 to V8.2 : what we found was that
at execution time DB2 was trying to convert the SP from the old, external,
format to the new, internal, format. The user running the SP did not have
authority to delete the old DLLs from the directory you noted above.
We eventually went through an exercise of deleting and recreating all the
SPs (we didn't have that many) to get round the problem, rather than giving
world update access to the directory in question.
HTH
Phil
Philip Nelson wrote: Serge Rielau wrote:
md********@gm ail.com wrote:
Hi all I am trying to call a DB/2 v8.2 stored procedure from Perl DBI and am getting an error message telling me, that the routine could not be found in the library path.
[IBM][CLI Driver][DB2/NT] SQL0444N Routine "*_deposit" (specific name "SQL05051919 0148810") is implemented with code in library or path "\finban.cac _deposit", function "finban.cac_dep osit" which cannot be accessed. Reason code: "4". SQLSTATE=42724
Since 8.2 stores stored procedures internaly as byte code, the libaries can indeed not be found in sqllib/FUNCTION/ROUTINE.
I tried to grant EXECUTE rights to all users on the packages found in syscat.packa ges but this changed nothing.
Im am working with v8.2. on Windows, ActivePerl 5.61(638) and DBD-DB2 0.76 and DBI 1.34. The problem you have is independent of PERL. Now in V8.2 SQL Procedures which are CREATEd in V8.2 ar eall internal. But external (java, C, ..) procedures or SQL Procedures created prior to V8.2 still have DLLs.
Cheers Serge
To add to what Serge says, we got exactly the same problem with SPs being called from VB after we migrated from V8.1 to V8.2 : what we found was that at execution time DB2 was trying to convert the SP from the old, external, format to the new, internal, format. The user running the SP did not have authority to delete the old DLLs from the directory you noted above.
Actually DB2 V8.2 for LUW will not convert SQL Procedures on its own.
I'm not sure what you observed, but it wasn't auto-conversion.
I do recommend to drop and recreate the procs in one shot though to
avoid problems many moons later with everyone scratching their head not
remembering that a conversion did take place eventually. We eventually went through an exercise of deleting and recreating all the SPs (we didn't have that many) to get round the problem, rather than giving world update access to the directory in question.
HTH
Phil
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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....
|
by: JN |
last post by:
Hello,
I'm having problem calling stored procedures from Visual
FoxPro database. I got the following exception error:
"System.Data.OleDb.OleDbException: Unrecognized command
verb"
It seems like the stored procedures are not recognized
by .Net.
|
by: Scott McNair |
last post by:
Hi all,
I'm having problems calling a stored procedure from within my code. If I
execute the SP manually from a Query Analyzer window it runs without a
hitch, but it seems it doesn't even fire when I try to run it from my code.
Anyway, here's both the VB code and the stored procedure:
With cmdCleanUncheckedSuites
.Connection =...
|
by: Jack |
last post by:
Hi,
I am trying to run an example code from a book. However I am getting the
following error message:
Number: -2147217900
Description: Syntax error or access violation
Source: Microsoft OLE DB Provider for SQL Server
SQLState: 42000
|
by: krishna1412 |
last post by:
Currently i am working in a project of report generation in MS ACCESS.
The tables are in sql server 2000.
I have to write stored proc in ms access.
Illustration:
I am having a stored proc as follows
name: myproc
-------------------
| |
by: eighthman11 |
last post by:
I'm calling a stored procedure on a sql server from an access
application. I just need the stored procedure to run I do not need any
data returned from the stored procedure to my Access application but I
do pass parameters from my Access application. What I have works fine
and is attached below. But I have one question. Why do I need this...
|
by: =?Utf-8?B?YW5vb3A=?= |
last post by:
Hello,
I have a stored procedure named as
usp_CheckLogin with two parameters
as @usID, @Password
also values of these parameters are to be extracted using Request.Form from
the fields in the forms. Now How do I call this stored procedure from an ASP
Page using a Connection object in Server Tags <% %>. Also this stored
|
by: yinzara |
last post by:
I have the following trigger that calls a DB2 stored procedure:
DROP TRIGGER GGWU.TRI_A_MULTI_PROP@
CREATE TRIGGER GGWU.TRI_A_MULTI_PROP AFTER INSERT ON
GGWU.MULTIPLIER_PROPERTY REFERENCING NEW AS POST FOR EACH ROW MODE
DB2SQL
BEGIN ATOMIC
CALL
GGWU.PKG_MULT_PROP_INSERT(POST.C_PROPERTY_CODE,POST.I_MULTIPLIER_ID);
END@
|
by: rajpar |
last post by:
Environment: Solaris (client + server)
db2 version 7.2 latest fixpak (DB2 v7.1.0.111", "s050516" and
"U803330")
Compiler: gcc
Here is my SP code executed on the client:
CREATE PROCEDURE db2user.x (IN value INT)
LANGUAGE SQL
BEGIN
INSERT INTO db2dba.t1 values (value);
|
by: Soniad |
last post by:
Hello,
I am excecuting a stored procedure in my ASP page , it has one out parameter (@confirm) . after executing the procedure i want to retreive this out parameter and assign it to variable (confirmation) declared in page.
Dim RsSp , SQLSp
Set RsSp = Server.CreateObject("ADODB.Recordset")
SQLSp = "Declare @confirm varchar(1)"...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
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. ...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
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...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |