Skip to main content

alphaWorks  >  Forums  >  Industry Formats and Services with pureXML  >  developerWorks

Help on HL7 schemas registration    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
Permlink Replies: 3 - Pages: 1 - Last Post: Feb 27, 2007 8:05 AM Last Post By: Ivan Clavijos Threads: [ Previous | Next ]
Ivan Clavijos

Posts: 8
Registered: Mar 08, 2005 06:02:23 AM
Help on HL7 schemas registration
Posted: Feb 26, 2007 10:14:21 AM
Click to report abuse...   Click to reply to this thread Reply
Hi there.

We are currently in the evaluation proccess of DB2 XML capabilities in order to use it in an application handling HL7 documents.

As I'm having some difficulties trying to store and, specially, retrive XML content that, I think, might be related with schema registrations, I would like to know if there is any kind of documentation or sample that can be downloaded of the HL7 demo you have in here.

If not, any pointer to any resource that can provide us with any additional information will be truly appreciated.

Many thanks in advance.

Best regards,
Ivan
db2xml42

Posts: 14
Registered: Jun 06, 2006 06:05:50 AM
Re: Help on HL7 schemas registration
Posted: Feb 26, 2007 09:45:58 PM   in response to: Ivan Clavijos in response to: Ivan Clavijos's post
Click to report abuse...   Click to reply to this thread Reply
We know of a problem with HL7 schema registration with DB2. We think we have a small workaround until the DB2 fix becomes available. Please contact me at malaika@us.ibm.com to see if the workaround applies in your case. The workaround is not required to store and query HL7 instance documents (messages) in DB2 - that should be fine.

Susan Malaika
db2xml42

Posts: 14
Registered: Jun 06, 2006 06:05:50 AM
Re: Help on HL7 schemas registration
Posted: Feb 27, 2007 07:45:06 AM   in response to: db2xml42 in response to: db2xml42's post
Click to report abuse...   Click to reply to this thread Reply
A suggestion:

Go to http://www.alphaworks.ibm.com/tech/purexml
Go to View Demo
Go to HL7
Go to Query
Go to "Click here for a list of sample queries"

Look at the queries - they all have a namespace declaration
Try something similar

Susan Malaika
Ivan Clavijos

Posts: 8
Registered: Mar 08, 2005 06:02:23 AM
Re: Help on HL7 schemas registration
Posted: Feb 27, 2007 08:05:57 AM   in response to: db2xml42 in response to: db2xml42's post
Click to report abuse...   Click to reply to this thread Reply
Hi, Susan.

It worked! :)

It was as simple as adding the namespace declaration to my xquery so it now looks like this:

XQUERY declare default element namespace "urn:hl7-org:v3";
db2-fn:xmlcolumn('TEST.INFO')/ClinicalDocument/informationRecipient/intendedRecipient/addr/city/text()

Thanks a whole lot for your help, Susan :)

Point your RSS reader here for a feed of the latest messages in all forums