DB2XML.Content fails to export into file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Antanas - 01 Dec 2005 06:52 GMT

VALUES DB2XML.Content(DB2XML.xmlclob(CLOB('TEST1')), 'C:/Test1.xml');

SQL0443N Routine "CONTENT" (specific name "*MLCONTENTCF") has returned
an
error SQLSTATE with diagnostic text "DXXC003E Unable to write to the
specified file. ". SQLSTATE=38X03

Do you know why?

Running DB2/NT 8.2.1

Reply to this Message

Serge Rielau - 01 Dec 2005 07:11 GMT

> VALUES DB2XML.Content(DB2XML.xmlclob(CLOB('TEST1')), 'C:/Test1.xml');
>
[quoted text clipped - 6 lines]
>
> Running DB2/NT 8.2.1

Permissions?

Cheers
Serge

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message

DB2 Harakiri - 22 Dec 2005 13:30 GMT

Windows 2003 DB2 v8.2 fp10
I'm testing extender functionality and i encounter the same error !
Permissions are not the problem (I have Local admin and SYSADM
authority).

Antanas je napisal:

> VALUES DB2XML.Content(DB2XML.xmlclob(CLOB('TEST1')), 'C:/Test1.xml');
>
[quoted text clipped - 6 lines]
>
> Running DB2/NT 8.2.1

Reply to this Message

marlon - 30 Dec 2005 16:44 GMT

Have you set the db2 registry variables for xml extender write and read
access on file system ( DB2_DXX_PATHS_ALLOWED_READ and
DB2_DXX_PATHS_ALLOWED_WRITE )

look here

http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=db2_dxx_paths&u
id=swg1IY63577&loc=en_US&cs=utf-8&lang=en

Reply to this Message

mark.gillis@landg.com - 17 Jan 2006 15:42 GMT

I'm getting the same error and I've been through the suggestions in
this forum and the web-sites, with no luck. I've got the environment
variables set:

E:\ddl\CV>set db2_dxx
DB2_DXX_PATHS_ALLOWED_READ=ANY
DB2_DXX_PATHS_ALLOWED_WRITE=ANY

and I'm trying to write from Content() to an existing local file:

E:\ddl\CV>dir E:\ddl\CV\CV.xml
Volume in drive E has no label.
Volume Serial Number is 12D4-1238

Directory of E:\ddl\CV

17/01/2006 14:35 0 CV.xml
1 File(s) 0 bytes
0 Dir(s) 15,745,024 bytes free

E:\ddl\CV>db2 "select db2xml.Content(db2xml.xmlvarchar(doc),
'E:\ddl\CV\CV.xml') from result_tab"

SQL0443N Routine "CONTENT" (specific name "*MLCONTENTVF") has returned
an error SQLSTATE with diagnostic text "DXXC003E Unable to write to
the specified file. ". SQLSTATE=38X03

I tried running dxxtrc and the message in there suggests it cannot
access the file, even though there are no restrictive permissions:

dxxChkRegistry: registry is null, no access allowed
dxxChkRegistry: filename = E:\ddl\CV\CV.xml, found = 0

Any help appreciated

Mark

Reply to this Message

marlon - 20 Jan 2006 08:50 GMT

Hi,
i am not experienced in windows, but if you say "set db2_dxx" in the
windows command line you set the environment variables from windows.
in db2 you can set the instance variables by starting the config.
assistent ( db2ca ) and then enter the menu to "db2 registry". here you
can choice the two entries and set them to any. this way have to work !

Reply to this Message