DSXchange

Cool. Just curious --- what did you use for the base64 conversion?

Ernie

...to add more detail to Craig's response, the problem is usually the fact that any random space or stray CRLF is just "noise" to an xml parser (such characters are formally ignored by the xml standard)....but a stray set of blanks, or a CRLF, or other odd character can ENTIRELY change the...

It sounds like an error in the method you are using to read the document from disk. Are you using the Sequential Stage? If this is true, change your job so that it uses the External Source Stage, and sending a "list" of xml documents to your xml Stage... Go to my blog url below and click o...

We'll assume you know how to get that entire tagged string as a row in a single column. For what you are doing, and these few columns, it is very easy.....however, you should spend time looking thru the many threads here on XML, and spend time with the documentation..... ...send this single column i...

...is your question "how to parse the XML string" or "how to retrieve the string from inside of DB2" ?

Ernie

Ok.... I have it on a vmware image...I'll fire it up and then get it out to you.

Ernie

first, be sure you are comfortable with the MQ stage. Have a test job that sends data from a RowGenerator or Transformer into MQ...be sure you are getting what you want. Best way to practice for XML is to have one large column going into MQ. second...test sending output direct from XMLOutput. Have a...

Not sure about the reporting, but how about using a Filter on the Info Server Administration Tab, "Users" view.....an advanced filter lets you select something like "Workbench User" and then only get a list of those users that have that specific role....

Ernie

I think this is what you are looking for ? <?xml version="1.0" encoding="UTF-8" ?> - <!-- Generated by Ascential Software Corporation, DataStage - XMLOutput stage - Mon Sep 13 18:11:42 2010 --> - <Details> - <officecode> 01 <DEP>FIN</DEP> <DEP>FEC</DEP> <DEP>TEC</DEP> </officecod...

There are no right or wrong ways, but I try to find the best "single" way to bring in the new "table" once you have things ready to roll into production.....it's not always possible, but if Cognos already knows about the new changed table, and has new report(s), then re-import th...

Which column is your repeating element? (with key = yes on the input link)? It should be your DEP column.

Ernie

It "could" be. But also, consider that the XML Output Stage is a sort of aggregating stage....unless you are using a trigger, it has to collect all of your rows before letting anything go....it also could just be a reflection of your job....if the "whole job" is your "whole ...

I have it working in 8.1 with FP1, and have used it at several customer sites with the same configuration.

Also --- vary the job type --- I've seen cases where WSPack works ok in Server and not in PX...

Ernie

It (tracing) works in 8.1 FP1, and lets you ultimately see the SOAP envelopes being sent out...and coming back in..... You certainly did the right thing with lsatur's suggestion, to separate the WSTransformers....there is too much activity based on the Description property to not have something in b...

...is that a "resolution"? I'm not sure what you mean by that....or perhaps more importantly, what you are expecting. Business Terms have a very important function in FastTrack, but not at .csv import time. The import, as we have defined above, for your source and target columns, works bes...