DSXchange

I really don't see what would be magical about the number 12. Perhaps a little triskaidekaphobia? Seriously, with all that's going on with your install, if you haven't brough in some professional help by now - do so. Open a case with your Support provider. Not sure how much anyone here can help, unf...

Thanks for your quick reply, but sorting is not possible because I have only 2 columns in hash file (member_key,sese_id) and member_key is key column. Not sure what having two columns in the hashed file has to do with the ability to sort. You stated that when you build a hashed file and send more t...

Reverse your sort order. Last one in wins, period - so if you want the 'first' one you need to make sure it arrives last.

<faultstring>java.net.UnknownHostException: developerdays.com</faultstring>

Would seem to imply your host name is incorrect.

If you need running counts within the job, then those system variables will do the trick. After job, for grand totals, best to stick with other mechanisms - DSGetLinkInfo, for example, which I would think is what you are using in your routine.

Sure. From a TCL prompt.

Simply running it via a Sequence job won't cause this error. Ensure you're still passing the correct parameters to the job.

What kind of 'light' are you looking for? Have you checked the online help for System Variables? The explanations are a little terse there but I haven't really needed more than that to know how to use them. Or if I did, a quick experimental test job or routine helped. @TRUE and @FALSE are just that,...

Seems like a difficult approach. Why not parse your multiple files and load the flattened data into a work table? Then extract the total data set from there and create a single proper file from it? A database table would allow you to help the XML generation by sorting or grouping, if needed. Seems t...

I've been known to be both. Back those up one after the other and what do you get? Not alot of sleep. [yawn]

But are you able to telnet to the DataStage server? That was the question.

Define 'normal'. It can depend on so many factors, some of which we're trying to help you quantify. So, your extraction from Oracle to a flat file job went from 5:47 to 4:53? What does that tell you? Not that much of a difference between the two versions runtimes, especially if you run it a number o...

Excellent. And freeware to boot.

http://www.info-zip.org/

I'm sure there's an equivalent for the command line package for WinZip which I have, didn't bother to check the syntax. Only caveat there is you need to have the registered version of WinZip, not still be freeloading off the 'evaluation' copy.

Ah... here we go.

Link isn't working for me. And it's more than just the missing 'www.' on dsxchange.com - the topic doesn't seem to exist or we need a different syntax. Can you try that again, please?