DSXchange

Tell us which tools and what you are trying to accomplish.

Ernie

hmm. It's interesting that you are getting "all" the rows. If the Web Service delivers a formal array, then usually you will get the first row only, but perfectly formatted, while the rest of the rows are tossed. So you may have something even deeper going on, depending on the definition o...

See how silly this conversation is? Copy is an EE Stage, and the history of the definitions we're discussing is based on "Server" jobs and stages. I'm sure that Lee could chime in and give us the old rules about things like implied transformers and such, but again...the significance isn't ...

In reality, does it matter? The formal terms "passive" and "active" have deep roots in Server.....and were later applied to EE Stages based on a variety of properties and behaviors. I'm not convinced that the definitions have much meaning (nor should they) as they did in the past...

best suggestion is to test the service using a tool like Actional SOAP Tester or SOAPUI or many other available test tools on the internet.... ...then...look at what the SOAP body wants, as most of those tools will let you look at the body before it is sent. Then you know what must be in the payload...

it would appear that you are using a sequential stage to output the file? ....use no delimiter and no quote characters (or 000 for both values if its a server job)....and send only one column (so you won't have a comma delimeter or any delimeter at all) out of your xmlOutput Stage, and use the "...

The MQ Connector supports both --- it's not DataStage that makes the choice --- it's the environment. If you have the MQ Server co-resident with DataStage, then it's a server connection, and if you do not, then you have the MQ Client API co-resident with DataStage and use the syntax and properties f...

Frankly speaking, I'd say it's poorly designed xml. There should be three elements, first, middle, last....or three attributes...first, middle, last. Now it's three repeating elements with a qualifier 'value' that is really "metadata". So..it is retrieved as three rows, as it should be. Pi...

...the new assembly is very powerful...but it can be tricky to decipher, especially early on... ...I can't be sure from your description, but it "sounds" like you are talking about having multiple unrelated groups as your proceed thru the structure. You might also have multiple "neste...

just a wild guess --- it is asking about msxml ? I recall there being a requirement for msxml 4.0 or similar...

Ernie

You'll need to do a few things... First, learn how to capture the entire response from your web service, the one that gives you the bits to hand back on a subsequent invocation. This is done in a simple manner by taking the output link from a succesful call to your sign-on invocation and editing it ...

...but there also was a WAVES subject in the area of world wide address verification.....

which did you mean?

not sure exactly what concept you are speaking of, but if you mean "end-of-wave", which is primarily reserved for real-time style jobs, you can find a general discussion about it here: http://dsrealtime.wordpress.com/2007/12/13/simulating-end-of-file-for-real-time-etl-transformations/ Ernie

congrats! ..and thanks for the follow-up verification.

That will be very difficult. Why not use Metadata Workbench? ...or for that matter, usage in DataStage? Describe what "kinds" of dependency you are looking for...

Ernie