Chuck,

Upper or lower case does not seem to matter.

I also created a variable and put the file name and I still get the error.

I'm getting a CPF428A error. In fact the job log is kind of weird because I get the error twice.
Here's the full error listing:
Open of member CBX_XML file CBX_XML in ZZVICKIW failed.
Open of member CBX_XML file CBX_XML in ZZVICKIW failed.
User-defined function error on member QSQPTABL.
User-defined function error on member QSQPTABL.
Trigger program or external routine detected an error.

The full CPF error is:
Message . . . . : Open of member CBX_XML file CBX_XML in ZZVICKIW failed.
Cause . . . . . : Member CBX_XML file CBX_XML in library ZZVICKIW was not
opened because of error code 1. The error codes and their meanings are:
1 -- The format for file CBX_XML contains one or more large object fields
and the open request did not indicate that large object fields could be
processed by the user of the open.

I'm running out of ideas for what to try next.

Vic

message: 2
date: Thu, 01 Oct 2015 11:25:19 -0600
from: CRPence <crpbottle@xxxxxxxxx>
subject: Re: XML Shredding get_xml_file question

On 01-Oct-2015 10:24 -0600, Vicki Wilson wrote:
<<SNIP>> when the data was part of an xml document on the IFS I
successfully used get_xml_file. But now when the xml is part of a
file the get_xml_file fails.

get_xml_file('mylibrary/CBX_XML(CBX_XML)')

The documentation says that get_xml_file should be able to retrieve
from a file "For a source physical file, the string must be in the
form 'library/file(member)'"

I've played with the syntax a bit - but nothing seems to work.

From the given example, consider that the IBM i object names are
upper-case, unless delimited by double-quotes. If that is playing any
part, I do not know if character case is relevant to the argument per
possible implicit folding for undelimited names [but also unknown how
contrived vs accurate reflection is the example or what else was tried],
then:

So the lower-case library name mylibr would be "mylibr" [per limited
to 10-characters inclusive of the delimiters, the example is shortened],
thus:
get_xml_file('"mylibr"/CBX_XML(CBX_XML)')

Most likely the library name is upper-case, so the library name
MYLIBRARY would be just MYLIBRARY, thus:
get_xml_file('MYLIBRARY/CBX_XML(CBX_XML)')

FWiW: The following DeveloperWorks topic discussed a failure for
access, if\when MYLIBRARY resides on an IASP:

Forum Directory ->? Information Management ->? Forum: DB2 for i ->?
Topic: GET_XML_FILE not corretly picking up source from iASP
[https://www.ibm.com/developerworks/community/forums/html/threadTopic?id=301bdc22-5263-4a7e-9b54-37e048aea07c]


This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].