DSXchange

...I'd probably dig deeper in the wsdl and any associated xsd's...find the namespace "ser" and look closely at the definition of the the "char" type.........maybe there are answers there. ...also, for fun, just make your own copy of this wsdl and change those types to xs:string.....

Definitely get to know the service via a tool such as SOAP ui so that you are very familiar with what it expects and what it returns. Another very useful test is to use a Server Job....even if only for testing the web service. The WSTransformer can be fully "traced" in a Server Job....(at ...

hard to say....especially since you have introduced "running" into the discussion. Without ever running the web service, import the wsdl. Look at the output link in DataStage after you have "loaded" the Message.....and look at the output definition that results from SOAPui. One p...

I can't think of a reason why it wouldn't work....the filename column (or any other column) on the input link is available just like any other for normal mapping at the output step. As a test, just to see if it has something to do with your xsd structure, create a whole new job that just passes the ...

yeah...20 to 30mb is still "small"...but certainly, as that number grows, or if you have 5,000 20 to 30mb documents, then the story changes. ...but if it's just 20mb, and its once per day? Again, your mileage may vary. At some point, regardless of which way you go, start the learning curve...

On the output link of your xmlOutput Stage have just one single column....make it a longvarchar with a length of (say) 99999 and put a single "/" in the Description property. That will send your entire manufactured xml content downstream in a single column on a single row (assuming you cho...

Your mileage will vary.....but some characteristics worth noting are: Server Jobs typically have far less initialization time....the whole job will finish and complete before the parallel Job even gets started....when the volumes are tiny, that could be important. Server Jobs tend to be more flexibl...

Welcome aboard! Everything said above is spot-on.....and the xml Stage will just "be there" with your 8.7 install, as will the others. There are times when the old stages are appropriate, particularly when the content is tiny (really small transactional types of xml documents) and when the...

each file in the subdirectory is a whole single "row". If you have multiple files, then they will be in multiple rows. If you need to combine them, you need to look at techniques for pivoting. There are many in this forum.

Do you want the commas and the delimeters to remain, intact? If so, that's the beauty of the folder stage --- it will pick up your whole file, "as is" and pass it downstream as the value of a single column on a single row, commas, crlf's and all. That is why I suggested you first play with...

and it must be enabled for use as a Service (the check box directly underneath "Allow multiple instances" at the Job details Edit page.

Ernie

Why use xmeta? Use dsjob.

You have a lot of pre-work to do.... a) determine how to call a web service from Java. Get it working stand-alone. This is a java skill independent of DataStage. If you don't know how to do it yourself, I would advise starting some web searches --- there are literally thousands of resources and othe...

I would probably instead just read the whole thing as a single row, and not worry about having to control the MQ writing side.... ...use a Server Job and read the file with the Folder Stage.....it has the ability to very easily consume the entire file as a single column......be careful if the file i...

Make sure that your linux/unix server (where WAS is installed) is able to ping/see the client windows machine where you have installed the Metadata Interchange Server. Make sure there are no firewall issues or other blocking. The server in this case must be able, as a client, to connect directly to ...