DSXchange

It's possible that the DB2 Connector (new with release 8) is required to understand the pureXML datatypes.........but perhaps pureXML has ways of loading xml from disk, which DS could produce....

Ernie

Have you seen this article? I haven't seen any sites using it, but perhaps this will help...

http://www.ibm.com/developerworks/data/ ... 1&S_CMP=FP

Is that the only character field? Perhaps it is not EBCDIC and is already in ASCII...that would make it look strange.

What are its hex values?

Ernie

Thanks. Strange that it worked via SOAPui.... it probably didn't or else it was using local windows authentication....is your DS Server on Unix or Linux?

Ernie

Did some testing..perhaps this will help you in your research.... Environment is Windows XP, with DataStage 8.1 and FP1. The xml document has a character copyright in it (as in your first posting) and also the decimal version of the copyright. IE 7, in my environment, blows up on the copyright symbo...

Anything else you can tell us about the job and the source file? How many rows ends up taking the 15 minutes? Also, what happens if you just have "Source File ---- Transformer --- (some target), and then a Constraint in the Transformer that is impossible (such as 1=0)....or you could also just ...

These things can get a bit strange, because they are often dependent upon encoding schemes. What is at the top of your document? Does it have a specific declaration of UTF-8 ? It may need to have it specifically included, or even an alternate encoding scheme. A quick search on the web should uncover...

Look carefully at the Description property of your output link......you should have something like /Name/FirstName . Anything else would be a typical reason for getting zero rows. Also...just in case, send your External Source stage link to a sequential file and be sure you are getting the filename ...

Have you considered a script that runs dsjob? Primitive, but it would work...a user could run it at the command line and it could spin thru various projects and dump the status of running jobs....... (you could also use the the dsjob api in C++ but that would be a lot more work).....

Ernie

Does the WSTransformer work in general? (with other services with smaller payloads, etc.)? If so, then you probably simply have a payload that is just too large. Ultimately, the WSTransformer has to receive and parse out the returned SOAP envelope (XML)....if the payload is so large that it is over ...

I'm not sure what parts of Info Server are impacted by OMD import, but it's possible that increasing the heap space for WAS would help...... ....But I would also want to talk about the OMD that you are importing? What is the goal for OMD in your scenarion withing the Metadata Workbench? Collecting O...

Hi Vincent.... Share Tables are created via several means, but Shared Files are today only created by using the "Create Shared Table from Table Def" or whatever the exact option is called from within DataStage. I generally do it via right mouse while on a standard DataStage Tabledef..........

I played a bit with this when the Connector first came out, but only in a lab scenario. I'd have to check my notes, but I recall that there was good detail on this in the manual, and at the very least, you needed the WSMQ.FORMATHEADERS (or something like that) Data Element in the output link as a co...

There's an entire pdf dedicated to it in the doc set. Start there too.

Here are some things to check and to look into...

Does it work in other Jobs? Have you had it working before in this Job? Does it work in a Server Job?

Ernie