DSXchange

:) Don't try to view xml within a DataSet. Good luck with that! The viewer can't interpret it anyway, and can only show you a piece of it. Even if it works on short documents, view it instead the right way when testing --- send it to a sequential file, with all formatting turned off (no "end of...

Fasttrack has capabilities within IS tool but I haven't had a chance to try them yet......I can't remember if it supports csv import or just export/import for migration purposes.

Ernie

The feature for validation is in the Stage..... the xsd is merely "available" on disk and indicated within the document that you are reading (there is an attribute called schemaLocation in the header or sometimes NoNamespaceSchemaLocation that will point to a full qualified name of the xsd...

Hard to say...not understanding yet what you are looking for......so far it looks like it is working just fine. relEntry is inside of relList and relList hasn't closed yet.... after ALL the relEntry elements for that relList, you should see a close of </relList> and then finally a close of </accEntr...

One more set of items worth checking...... what element do you have marked as a key? ...and are you using "aggregate"?, and then separately, what happens if you force seqnum to be unique?

Ernie

I have no idea. Never seen that happen directly.....but I wonder about the hierarchy you are creating.... Do you have a "perfect" example version of the whole structure that you would like to create? How do the accEntry elements relate to the relEntry elements? are they one:one ....or can ...

Thanks for the update Doug... Good info.

Another way to review this is to look at why any column updates are needed? ...and if it's to get the connector to behave the way you want, then maybe the issue is with the Connector runtime....

Ernie

Can you provide more details, or cut/paste a resulting small output example? Is it only for one particular row? for any and all of your accEntry instances? Does msgId close correctly? Does accList close correctly? Are the values null? are the values empty?

Ernie

ok...good...so hopefully it is here on the DS side. There's a few APT variables you need to check that impact the size of a column on the link....I don't remember which ones at the moment, but if you search the forum here on MQ and XML you'll find them fairly quickly. Also, if the MQ Server is co-re...

Check MQ itself...it has limits on message size also. Did you create the queue yourself? Do you have access to the command line utilities of MQ? Do a display of the queue (display qlocal command of the runmqsc command, depending on your release of MQ).... there is a max message length value there......

What error do you get? Are you even able to import the metadata? Exactly which Oracle Stage are you using? I haven't talked to a site who has done this...perhaps others here in the forum have. There is new xml datatype support for various databases inside of the Connectors in 8.5, but again, I haven...

Cool! Congrats...

...no only once for each particular "alias" and possibly a variety of stage types... ...and only for those jobs where it is particularly useful to see the actual "table". There are a lot of uses for lineage. One is to quickly find out what the flow of stages is between a whole lo...

The answer is in the Database Alias link at the Advanced Tab..... each string that is used as a "Server name" or "DSN" name is just an abstraction. You define, at that page, for each abstraction and each Stage/Connector type, which "Host" and "Database" among ...

Did you go to the Advanced Tab of Workbench and review the "Database Alias" link?

Ernie