DSXchange

Another useful question is exactly how large are we talking about?

Not sure.....prior to your submitting those dummy requests (ie..when you know you are going to have a long-response-time condition), take a look in the DS Director....are the instances up and running and available? That would be the first thing I would check....possibly there are issues with CASS an...

If it is truly a SOAP based web service then the content of the xml inside the payload (when xml is being passed as the actual input data), then by design it has to be "escaped" on the wire [xml inside of xml]. The receiving application, when normally de-serializing the SOAP payload, will ...

Look at the "xpath" in the Description Properties of the output link of the xmlInput Stage....see if they have prefixes defined in the xpath (such as /xyz:name ) ...if so, then you need the namespaces to be "in" the actual xml......or not, if they aren't there. Look at your docum...

Just some thoughts...

...do you get the request and response nicely when you call the TemperatureConversion service?

...and another thought (although I would expect this to blow up prior to the request going out) are the datatypes....what are they? Anything different or odd about them?

Ernie

Ok...if you have at least one that is working, it is sometimes helpful to trace the activity of the invocation.... Build your Job as a "Server" Job....(do this first with the temperature conversion service that you know works).....then when you compile and run it, click on the "Tracin...

Is this in 9.1 ? I heard of an issue in some cases with 9.1 and there may be a patch available. Contact your support provider. If it is not 9.1, have you ever gotten "any" web services to work?

Ernie

I have found it necessary at times to include a dummy element in the node with an artificial key (use a counter in an upstream transformer to create this additional column)....then the rows are ultimately unique and you'll get the groupings you need.... ....depending on the downstream application, t...

I remember that being an issue, but not sure when it was corrected. I can definitely put carriage returns in my 9.1 and they remain.

Ernie

All of this is a correct discussion about escape characters and xml, but it would be useful to add some more context.... The initial post notes: "I am reading a string from a 9.7 DB2 table. The string contains the ampersand sign........When I pass the VARCHAR string to an XMLInput Stage.......&...

It depends...if you have multiple "paths" of that hierarchy (such as a company xml document with "employees" and also an unrelated "products") node, then they have to be related together with other steps..... Usually, if you have only one input link coming in, which is ...

I am not a Netezza expert, so I can't comment on the viability of the possible stage types, but it looks like the Netezza Enterprise Stage has the option for CREATE, as does, of course, ODBC. The Netezza Connector doesn't appear to, at least at first glance, but there may be ways that I am not aware...

I do this all the time because I'm always "in" DataStage and often too lazy to fire up one of my SQL tools....use one of the target stage types that has a "Create" option...it will generate CREATE DDL from the input link column list and then load it...

Ernie

hard to say....be sure you ping the windows box from the server and vice versa, and be sure that there is no firewall between them. The server has to reach out to (for this purpose) be the "client" to the windows machine. Also make sure that you have a tomcat6 process running on your windo...

Another thought is that the answer might be far more complicated than just looking at the metadata in the repository...the source and target may be defined only by the values passed into the Job at runtime....in those cases, the best way to obtain the information is to use the Metadata Workbench, sp...