DSXchange

ITtoolbox (I believe the same infrastructure where Vince hosts his blog?) has a "group" for Infa. Not sure if it is the "best" INFA resource but it seems to get it's fair share of traffic. Perhaps there is another powerful "dsXchange" type site out there..... but still,...

Sorry...I don't understand the problem description. Not sure what "one Xpath of THREE Attributes in one Column" means.......? xmlOutput takes AN input column value from an incoming link and creates an attribute "or" an element. It can't create "multiples".....not sure w...

Sorry...I don't understand the problem description. Not sure what "one Xpath of THREE Attributes in one Column" means.......? xmlOutput takes AN input column value from an incoming link and creates an attribute "or" an element. It can't create "multiples".....not sure w...

...don't think of it as being "unique"...the property called "key" is simply used to mark the "lowest level element" that repeats...(on each link there will be one)

Ernie

I haven't tried it directly myself, but do some searches on IBM Developer Works....there is an article there that talks about using XMLPack with DB2's XML capabilities. I don't have time to check right now, but I think I have a pointer to the site in my blog below, referencing a good article on xml....

Hard to say what the timing is on the opening of the queue, but the job will always abort anyway, if the database is not up and available when the job is initialized.......

Ernie

It should be...as 3 separate columns on the input link...two that are defined as attributes of Property and one as a sub-element....

..../PROPERTY/@<name of attribute>
.../PROPERTY/@<name of other attrib>
.../PROPERTY/VALUE/text()


Ernie

Hi all... There are a variety of issues here...first, this looks like a pretty complex XML structure (meaning -- many nodes that repeat, independent of each other)....think of a "company" hierarchy that has company info at the top and a node for employees, and another node for assets..... ...

Confused here too..unless you are saying that you want to send "some" data to a database and "some" to XML (maybe similar or "same" xml) but italicized?

Ernie

There's a "truncate on metadata mismatch" setting...make sure that is not set.....

Ernie

Tell us more about the rows coming in and their values. At this point I'm not sure of the objective.

Ernie

Make sure that you are really creating xml at all.....put a single column on the output link of xmlOutput.... call it "myXMLstring" and give it a longvarchar and a length of something like 1000.....put a single "/" in the Description property. Use just a couple of rows as a test,...

ah. boo. xsd.exe is nice, but it does the opposite only, from what I can tell. Just took a closer look and it nicely creates xsd from xml, but not xml from xsd.

Ernie

Search thru the forum here. Find the "XML Best Practices"....link to kduke's site where you can find it. It goes into detail on how to create complex, multi-node XML. It's not particularly easy, but it can be done.

Ernie

I used to use XMLSpy, but my license ran out. It did it nicely as I recall. This is one of those things I only need once in awhile, so I'll try to find whatever I can. Often at customer sites, the author of the xsd will have a tool and can immediately generate an xml doc for me. A quick search on th...