DSXchange

Sorry, that's a new one on me and a search of the forums doesn't reveal anyone posting that message before. Suggest you contact your official Support provider.

How about using the wildcard as stdin for sed (so they work one at a time) and append-redirecting the output into your file? Err... meaning... this? sed -e 's/$/|M' *.xxx >> fileout I'll give it a shot. Edited to add: WTH? The substitution syntax that worked fine in the other form won't parse in th...

kcbland wrote:Syncsort available?

Sadly, no.

The word 'load' is used interchangeably at my workplace for inserts and updates. And the word 'bulk' is being used incorrectly. A 'bulk' load implies one of the stages that leverage sqlldr and therefor have some form of 'bulk' in their name. You've just got plain ol' DML updates where I guess bulk ...

This does work but adds some overhead. Cat'ing 2.6M records went from 23 seconds to 1 minute 23 seconds. I can live with that but still curious if there is something less impactive that could be done.

Thanks - running some timing tests. I can pipe cats through sed:


Two birds, one stone. :D

Not really a DataStage question as I don't want a job solution, but a UNIX one. I have 16M records in 51 identical files that need to be concatenated together for processing. I'd like to add a single letter as a trailing pipe delimited column to each record during the process, if possible. I know wh...

'As early as possible' takes a phone call to your Support provider. These are all volunteer forums and people help when they can, if they can.

First line of defense would be a search of the forums for your error - you're not the first person who's ever seen a mutex error.

ivannavi wrote:I didn't write poop. I wrote s..t. Is this forums engine inteligent or what?

Nah, just a prude. If it was all that smart, it would have added your missing 'l' for ya. [/joke]

Ray - assembly language puns? Oi vay...

You know the job name but not where to find it? Use the Administrator:


You can also utilize the Filter Entries and uncheck the Show Categories option in the Director - in that order! Reverse the order once found.

I sense a great disturbance in the Force... Does your last sentence mean that if someone upgrades to 8.x then all Server jobs will run with a 'performance penalty'?? Yes, no, maybe so? What if there is no 'parallel environment' per se, a situation where someone running XE with only Server jobs lice...

Could very well be. The complete error should reveal all, at least to them.

No. The timeout is specific to the job starting - not about how long it takes to start processing records once it has started.

Here is a techinque from Ken Bland that I've used to great effect. Nutshell: a single cached hashed file record with 'arrays' like you are using to do your range check via the Locate function. The explanation is a little long, but the basics are pretty easy to grasp. You could short-cut some of the...

Nothing magical about the 'PX environment' - just run them. Sequence jobs can run either and there's no need to put them in a container in a PX job.