DSXchange

I'd like to write one. :) I have a number of things on my blog (see below) as I collect a long list of techniques and ideas and find time to write about them, and I have heard that there is a redbook project being put together that will cover metadata issues. In the meantime, search the threads here...

Wish I knew more about the NLS guts for you. The xml stages went thru a fairly extensive overhaul from 7.x to 8.x....mostly to add/replace the generally open source apache parser and processor that were used with Ascential with the ones required from an IBM perspective. I have no idea of that has an...

Where exactly are you with 8.1 ? While I haven't heard of any NLS issues in particular, there were many other things wrong with the initial xmlPack in 8.0, and a few subtle things that remained in 8.1 ....a first check would be to see if you have you applied the overall FP1 for 8.1 ? It would be the...

ok...let's clarify then.....is your Operation returning "more than one column".....or is the Operation returning "more than one ROW"...... ...it's the "more than one row" that is the crucial piece of this....although it wouldn't surprise if the new "structure"...

No..... the WSPack (Web Service Tranformer or WS Client Stages) in DataStage has never supported arrays. It isn't able. There are ways to get around this, but the WSPack itself is happiest with single row in, single row out services. All I'm doing is trying to separate the issues. Issue number one, ...

The problem is not with ISD....it's with Web Services Pack. The WSPack can't easily handle services with arrays. There are ways to do it, but for the moment I will assume that your real future client is a java or .NET application somewhere that wants to use your ISD DataStage or QualityStage based s...

....your problem "may" be due to a need for increasing one of the APT variables that affect size of data on the links.....I don't have access to DataStage at the moment so I can't check, but it's something like APT_TRANSPORT_BLOCKSIZE.... do some searches here on the forum. THere are proba...

Figuring the right support for an encoding issue is always a challenge.....it's hard to find out what really needs to be done, or what is at fault.... From the looks of your symptom, the error appears when you try to look at the resulting file..... What are you trying to look at it with? Perhaps it ...

In a previous life I recall having a saying that "Default" and "Disaster" both begin with the letter "D"......meaning --- if you care about it, assign it a value manually...... A curious discussion, but in the end, give it something so that it never becomes an issue one...

With 8.5 you can use one XML Stage.... in releases prior to 8.5 you use multiple coordinated XMLOutput Stage....Seach the forum for Kim Duke's web site and the XML Best Practices Guide ....it outlines how to do this along with many other techniques.

Ernie

I don't have time to try it, but I'd probably use the "Generate Chunk" check box option, and then experiment with the Nested Chunk tab (text option). If that fails, then just send your xml downstream as a "chunk" and concatenate the simpler header to the front of it in a Derivati...

We'll need a lot more details....I'm not sure if MQ is the source or your target........and "commit" doesn't apply to a dataset.

...so I'm not exactly sure what your symptom or problem is. Can you describe what your job looks like?

Thanks.

Ernie

I haven't had a chance to test it extensively, but in 8.5 the Connectors offer this capability directly. Alternatively, it can be done prior to 8.5 in a Server Job. Each link coming from a single Transformer can go to a separate table with its own SQL, and then a single commit can be utiilized. Been...

I'd consider other factors also before making a decision on which way to go here.....consider such things as: Is the max number of files 50? Or is that just your current number, and it could eventually be 500? Are the files large? or will they eventually be large? Will you need parallel processing o...

Do some searching in the forum. You will need to learn separately about xmlOutput and also about JavaPack. I have an example of JavaPack at my blog below and also various things about XML, but there are tons of good threads here by many of us on general java and xml subjects.

Ernie