Hi Folks,
I'm getting this message with the XML tutorial: getstart_export XML.cmd file:
SQL0444N Routine "DB2XML.CONTENT " (specific name "DB2XMLCONTENTV F") is
implemented with code in library or path "\db2xmlfn" , function
"dxxContent_var char2file" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
DB20000I The TERMINATE command completed successfully.
db2xmlfn.dll is in E:\SQLLIB\FUNCT ION as well as others, like db2clifn.dll
(I tried ABS in SQL and it works).
Do you have any ideas to solve this problem ?
Thanks,
JM
12  2876 
I forgot: DB2 UDB V8.2 FP9 on Windows.
"Jean-Marc Blaise" <no****@nowhere .com> wrote in message
news:42******** **************@ news.wanadoo.fr ... Hi Folks,
I'm getting this message with the XML tutorial: getstart_export XML.cmd
file:
SQL0444N Routine "DB2XML.CONTENT " (specific name "DB2XMLCONTENTV F") is
implemented with code in library or path "\db2xmlfn" , function
"dxxContent_var char2file" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
DB20000I The TERMINATE command completed successfully.
db2xmlfn.dll is in E:\SQLLIB\FUNCT ION as well as others, like db2clifn.dll
(I tried ABS in SQL and it works).
Do you have any ideas to solve this problem ?
Thanks,
JM
Jean-Marc Blaise wrote: I forgot: DB2 UDB V8.2 FP9 on Windows.
"Jean-Marc Blaise" <no****@nowhere .com> wrote in message
news:42******** **************@ news.wanadoo.fr ...
Hi Folks,
I'm getting this message with the XML tutorial: getstart_export XML.cmd
file:
SQL0444N Routine "DB2XML.CONTENT " (specific name "DB2XMLCONTENTV F") is
implemented with code in library or path "\db2xmlfn" , function
"dxxContent_v archar2file" which cannot be accessed. Reason code: "4".
SQLSTATE=4272 4
DB20000I The TERMINATE command completed successfully.
db2xmlfn.dl l is in E:\SQLLIB\FUNCT ION as well as others, like db2clifn.dll
(I tried ABS in SQL and it works).
Do you have any ideas to solve this problem ?
ABS is SYSIBM.
Try SYSFUN.APPLICAT ION_ID() and see what it does.
Is this the first time you try to use DB2XML.CONTENT( )?
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
"Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:3e******** ****@individual .net... Jean-Marc Blaise wrote: I forgot: DB2 UDB V8.2 FP9 on Windows.
"Jean-Marc Blaise" <no****@nowhere .com> wrote in message
news:42******** **************@ news.wanadoo.fr ...
Hi Folks,
I'm getting this message with the XML tutorial: getstart_export XML.cmd
file:
SQL0444N Routine "DB2XML.CONTENT " (specific name "DB2XMLCONTENTV F") is
implemented with code in library or path "\db2xmlfn" , function
"dxxContent_v archar2file" which cannot be accessed. Reason code: "4".
SQLSTATE=4272 4
DB20000I The TERMINATE command completed successfully.
db2xmlfn.dl l is in E:\SQLLIB\FUNCT ION as well as others, like
db2clifn.dll(I tried ABS in SQL and it works).
Do you have any ideas to solve this problem ?
ABS is SYSIBM.
Try SYSFUN.APPLICAT ION_ID() and see what it does.
Is this the first time you try to use DB2XML.CONTENT( )?
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Hi Serge,
Yes.
Jean-Marc
Jean-Marc Blaise wrote: "Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:3e******** ****@individual .net...
Jean-Marc Blaise wrote:
I forgot: DB2 UDB V8.2 FP9 on Windows.
"Jean-Marc Blaise" <no****@nowhere .com> wrote in message
news:42***** *************** **@news.wanadoo .fr...
Hi Folks,
I'm getting this message with the XML tutorial: getstart_export XML.cmd
file:
SQL0444N Routine "DB2XML.CONTENT " (specific name "DB2XMLCONTENTV F") is
implement ed with code in library or path "\db2xmlfn" , function
"dxxContent _varchar2file" which cannot be accessed. Reason code: "4".
SQLSTATE=42 724
DB20000I The TERMINATE command completed successfully.
db2xmlfn.dl l is in E:\SQLLIB\FUNCT ION as well as others, like
db2clifn.dll
(I tried ABS in SQL and it works).
Do you have any ideas to solve this problem ?
ABS is SYSIBM.
Try SYSFUN.APPLICAT ION_ID() and see what it does.
Is this the first time you try to use DB2XML.CONTENT( )?
Yes.
And I take it SYSFUN.APPLICAT ION_ID() works..?
What about permissions on db2xmlfn.dll are they the same as for
db2clifn.dll ?
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
"Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:3e******** ****@individual .net... Jean-Marc Blaise wrote: "Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:3e******** ****@individual .net...
Jean-Marc Blaise wrote:
I forgot: DB2 UDB V8.2 FP9 on Windows.
"Jean-Marc Blaise" <no****@nowhere .com> wrote in message
news:42***** *************** **@news.wanadoo .fr...
>Hi Folks,
>
>I'm getting this message with the XML tutorial: getstart_export XML.cmd
file:
>SQL0444N Routine "DB2XML.CONTENT " (specific name "DB2XMLCONTENTV F")
is>implement ed with code in library or path "\db2xmlfn" , function
>"dxxContent _varchar2file" which cannot be accessed. Reason code: "4".
>SQLSTATE=42 724
>DB20000I The TERMINATE command completed successfully.
>
>db2xmlfn.dl l is in E:\SQLLIB\FUNCT ION as well as others, like
db2clifn.dll
>(I tried ABS in SQL and it works).
>
>Do you have any ideas to solve this problem ?
>
ABS is SYSIBM.
Try SYSFUN.APPLICAT ION_ID() and see what it does.
Is this the first time you try to use DB2XML.CONTENT( )?
Yes.
And I take it SYSFUN.APPLICAT ION_ID() works..?
What about permissions on db2xmlfn.dll are they the same as for
db2clifn.dll ?
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Application_id( ) works and permissions on both dll are the same:
read&execute + read + write for DB2USERS and all for SYSTEM,DB2ADMNS +
Administrators.
"Jean-Marc Blaise" <no****@nowhere .com> wrote in message
news:42******** *************@n ews.wanadoo.fr. .. "Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:3e******** ****@individual .net... Jean-Marc Blaise wrote: "Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:3e******** ****@individual .net...
>Jean-Marc Blaise wrote:
>
>>I forgot: DB2 UDB V8.2 FP9 on Windows.
>>
>>"Jean-Marc Blaise" <no****@nowhere .com> wrote in message
>>news:42***** *************** **@news.wanadoo .fr...
>>
>>
>>>Hi Folks,
>>>
>>>I'm getting this message with the XML tutorial:
getstart_export XML.cmd>>
>>file:
>>
>>
>>>SQL0444N Routine "DB2XML.CONTENT " (specific name "DB2XMLCONTENTV F") is>>>implement ed with code in library or path "\db2xmlfn" , function
>>>"dxxContent _varchar2file" which cannot be accessed. Reason code:
"4".>>>SQLSTATE=42 724
>>>DB20000I The TERMINATE command completed successfully.
>>>
>>>db2xmlfn.dl l is in E:\SQLLIB\FUNCT ION as well as others, like
db2clifn.dll
>>>(I tried ABS in SQL and it works).
>>>
>>>Do you have any ideas to solve this problem ?
>>>
>
>ABS is SYSIBM.
>Try SYSFUN.APPLICAT ION_ID() and see what it does.
>
>Is this the first time you try to use DB2XML.CONTENT( )?
Yes.
And I take it SYSFUN.APPLICAT ION_ID() works..?
What about permissions on db2xmlfn.dll are they the same as for
db2clifn.dll ?
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Application_id( ) works and permissions on both dll are the same:
read&execute + read + write for DB2USERS and all for SYSTEM,DB2ADMNS +
Administrators.
Serge,
I get the same behavior on anoter PC with same config V8.2 FP9 / W2K.
HTH,
JM
Jean-Marc Blaise wrote:
Application_id( ) works and permissions on both dll are the same:
read&execute + read + write for DB2USERS and all for SYSTEM,DB2ADMNS +
Administrators.
Serge,
I get the same behavior on anoter PC with same config V8.2 FP9 / W2K.
This looks like an installation problem to me. Most probably there are some
dependencies of the lib that could not be resolved.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
"Knut Stolze" <st****@de.ibm. com> a écrit dans le message de
news:d6******** **@fsuj29.rz.un i-jena.de... Jean-Marc Blaise wrote:
Application_id( ) works and permissions on both dll are the same:
read&execute + read + write for DB2USERS and all for SYSTEM,DB2ADMNS +
Administrators.
Serge,
I get the same behavior on anoter PC with same config V8.2 FP9 / W2K.
This looks like an installation problem to me. Most probably there are
some dependencies of the lib that could not be resolved.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Hi Knut,
Thanks for your comment.
The only dependency problem that is referenced on the IBM support site for
SQL0444N is about msvcp60.dll, that is also used by the db2xml.dll function.
But, the dxxadm enable_db command and other functions that seem to use the
db2xml.dll function work perfectly.
To install 2 PCs and get the same problem, on Windows, make me think the
problem is not linked to the installation ... I have switched DIAGLEVEL to
4 but did not get better help. It's a pitty to have such a message and not
being capable to diagnose the source of the problem :-(
Everything works fine on Linux though ...
Regards,
Jean-Marc
Jean-Marc Blaise wrote: "Knut Stolze" <st****@de.ibm. com> a écrit dans le message de
news:d6******** **@fsuj29.rz.un i-jena.de...
This looks like an installation problem to me. Most probably there are some dependencies of the lib that could not be resolved.
The only dependency problem that is referenced on the IBM support site for
SQL0444N is about msvcp60.dll, that is also used by the db2xml.dll
function. But, the dxxadm enable_db command and other functions that seem
to use the db2xml.dll function work perfectly.
There are two different libraries: "db2xmlfn.d ll" and "db2xml.dll ". The
former is the one that contains the logic of the UDFs and the latter
contains the stored procedures, for example enable_db. So a proper
functioning of db2xml.dll does not say that dependencies of the UDF-library
are fine.
I had a look at the differences of the dependencies between the two libs,
and db2xmlfn.dll needs additionally an XSLT library (besides a couple other
DB2 libs). This library should be installed as part of the DB2 engine
under sqllib/bin/. In my installation, I have there
sqllib/bin/xml4c_5_3_0.dll (which should be working for you given that
enable_db succeeded) and sqllib/bin/xslt4c_1_6_0.dl l. If you don't have
the 2nd lib, it might be the reason for the problem.
To install 2 PCs and get the same problem, on Windows, make me think the
problem is not linked to the installation ... I have switched DIAGLEVEL
to 4 but did not get better help. It's a pitty to have such a message and
not being capable to diagnose the source of the problem :-(
SQL0444, rc=4 is usually a pure operating system thing. DB2 uses OS calls
like dlopen() to load a library, and the OS handles the dependencies. If
one of the dependencies cannot be loaded, then the loading of the requested
library fails. The OS doesn't give any additional information to DB2
regarding the actual reason for the failure.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Justin |
last post by:
I have a program that downloads files from the web. There are
instances in which a .info() will not return a "Content-length" header
to me. Is ther a way to specifically request this header or FORCE it
to be sent? I know there is some way to get the file size for these
files because Internet Explorer is capable of determining the size on a
cut / paste of the same exact url.
|
by: Blue® |
last post by:
I would like to call the content of content.htm (containing only HTML
codes) into index.htm.
This is usually done by renaming index.htm to index.shtml and use this tag:
<!--#include file="content.htm" -->
But I do not want to use SSI. Is it possible to call it using something
like:
|
by: Michael Strorm |
last post by:
Hi!
I've been having problems with a DTD. Having had the Sun XML validator
reject a document, I put it through 'xmllint' for more information.
'Xmllint' noted a problem with the DTD itself;
"validity error : Content model of section is not determinist: (text ,
(list , text)* , list?)"
Here's a very simplified version of the DTD demonstrating the problem:-
|
by: J.Edwards |
last post by:
I'm getting this error when trying to use a control built in VS 2003 (1.1)
in a new asp project in VS 2005.
"Content controls can only be used in a content page"
The control has always worked ok in 2003, and I've not seen this error
before so does anyone know what it could be? Can't find anything on the web
about it.
|
by: Phil |
last post by:
I am writing an application (using Visual Studio 2003) that consumes a third
party Web Service, but I receive the following error :
Client found response content type of 'application/xml; charset=utf-8', but
expected 'text/xml'.
I can see the XML Document and it is properly structured. Is there any way
to overide this and get .NET to process the response XML regardless of the
Content Type Setting in the HTTP Response ?
| | |
by: Trapulo |
last post by:
I've this statement in my output's creation:
Response.Clear()
Response.ContentType = "application/vnd.google-earth.kml+xml kml"
Response.AddHeader("Content-Disposition", "inline; filename=Log_" &
activityLogID & ".kml")
The strage is that on my development server all works (IE try to open the
|
by: Kevin Frey |
last post by:
We have a data-centric application where all of the "layout" for each data
centric page is to be codified (ie. it is expressed in C# code rather than
being expressed declaratively). This codification subsequently produces the
required web-controls for a page based on whether the page is eg. in view or
update mode, examination of the user's security permissions for certain
fields, etc.
In VS2003 our "Page Master" (to use the VS2005 term)...
|
by: dave8421 |
last post by:
Hi,
I'm trying to make sense of the definition for "Rendered Content" in
current CR for CSS 2.1
Is rendered content what is displayed on the particular media or
device? from the definitions, I got the impression that the rendered
content is referring to the source document and not the particular
|
by: Alexander Smirnov |
last post by:
I'm developing asp.net 2 web application and need to make a custom
http handler which sometime must send response with "204 No Content"
code.
I set HttpResponse.Status="204 No Content"; But asp automatically adds
headers such as "Content-Length: 0".
This causes an error on the client. HttpResponse.ClearHeaders()
doesn't help. How to make asp not to add headers (especially Content-
Length)?
Thanks in advance.
|
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...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
|
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
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
