DSXchange

Even if you have a similar error message, please start a new post and tell us the gory details of the issue you are facing. I sincerely doubt you are migrating a 7.5 PX job from SUN to AIX.

Wow... or simply e) Moderator moved it to the proper forum. I can't help it that the way Ray moves through the forums nukes the 'moved' notice.

Please take the discussion back over there, then I'll remove this one.

"Fine" is a relative term.

It can certainly appear to work but that doesn't make it a good practice. Best practice is to do what you are doing.

Not possible.

I suspect that is still true as well.

You really need to involve your official support provider, if you haven't already.

Welcome! 1. Is it a good/reasonable solution? Unfortunately, no. And not a DataStage thing, just simply the fact that sequential media only supports a single writer process at a time. You'd either need to funnel all of your links to a single link before the Sequential File stage or create two jobs -...

So you are actually looking to source directly from the site itself, an HTTP source? I don't believe that is supported unless that has changed in the 9.x world, assuming it hasn't then you'd need to code something up in Java and leverage that.

Actually, what you'll find is either formatting is just fine but you're better off using turning off all formatting in the stage and letting it produce XML that is "one long line". Those formats are for people, to help make it easier to read for a person. No automated consumer should care....

What 8.x release are you on? I thought the WISD stuff was all included now.

Running it on one node would certainly rule out partitioning issues if they continue to occur.

It's a CHAR, they pad on the right as any other string would. Nothing "bad" about that. Now, if you need them left-padded / zero filled, that's a whole different requirement as you've addressed.

[Edit] So noted, modified to say "bad for a number", which it usually is - Andy

DataStage doesn't have the ability to select output file names based on data values until Revision 9.1. Other than the Folder stage in a Server job or Server Shared Container but it too falls into the 'ugly' camp. Oh, and technically the XML Output stage. Sorta. :wink: [Edit] So noted! I modified m...

Improper partitioning, I would think. More than one node? If so, how are your target streams partitioned? See if hash partitioning over the key fields helps.

As noted, lots of DOS help out there. Here's one I found with a quick search:

http://www.dostips.com/?t=Snippets.ZeroBytesCheck