DSXchange

Or concatenate them all together and return one.

That's... odd. Have you determined the pattern here, which dates are ok and which get corrupted? What are the NLS_DATE_FORMAT settings for your instances?

The first half in one partition, the second in the other, just by 'partition settings'? No.

Want or not want, use an aggregator. Group on the 'no calculation' columns.

No. See if your DBA can help, trace the session and see what the 'hang' might be... or at least help determine if it is database related or not.

Show us exactly how you are using it, please. Copy/paste that part of your script here.

Which "Ora" stage, exactly? And how are you passing in the password?

Are you certain it is fixed-length? Doesn't sound like one if you can't divide the total byte size by the record count and get an even number.

Details, please... Database? Stage? etc

Is your "varchar(50)" in SQLServer 50 bytes or 50 characters? You may have a 'byte semantics' issue with a multi-byte character set. What is/are the charactersets involved here?

Do that to set it, you can 'echo $DSHOME' to find what it is already set to.

Double-quotes inside a field? No. Well, unless you consider leveraging an O/S command like awk from the Filter option in the stage to be that. Then yes.

Ok... a) that's just a catch-phrase, much like "Resistance is futile!" from Star Trek or Hitchhiker's. b) This has nothing to do with DataStage. What the 'stupid' (since we're already down that rabbit hole) part is due to the nature of sequential media - it is the fact that it is physicall...

And since we're in the General forum... Server routines are written in DataStage BASIC and can be used in much the same manner as Ray noted but in the Transformer stage in a Server job. They also are what you can run 'Before' or 'After' jobs or stages and are what the Routine Activity stage in Seque...

It's a 'reusable object'. Write once, leverage in multiple jobs, change in one place, all places see the same change. Does that help at all? Not really associated with [what you put in the square brackets] by the way. The concept of shared containers works the same Server v. Parallel and you can eve...