DSXchange

If so, then it is two conversions - first a StringToTimestamp using the existing external format (no need to change any delimiters) followed by a TimestampToString using the new desired external format.

Are we talking about two strings? They would have to be for this to make sense but wanted to explicitly check.

Start by posting the abort messages.

Exactly exactly.

Asking over and over in multiple threads does not help. They are the exact same error in all your posts regardless of the source you are using. That really should tell you that the wrapper or external filter or whatever is not the source of the problem. Have you searched? Some advice is out there in...

I'm not sure I'm seeing a problem. Does the data in the table actually include the double-quotes as shown? If so, in Oracle's world the proper way to write that out is by adding a double-quote to each one as you are seeing. That's the only way they'll be preserved as part of the data on the way back...

I think there's some confusion around what the word "distinct" means. Regardless, as noted twice now, a fork join design will get you your desired outcome.

No, according to your text and samples more than one distinct value in the "Value" column for a Key makes it go to Link 2. So in your example, A has three values but only one distinct value -> Link 1. B has three values but two distinct values -> Link 2. The fork join will handle all that ...

Really?

Since you need to process the entire group before you know what link any of them should go down, I'd suggest a "fork join" design where you evaluate the groups for the number of distinct values and then use that as a lookup for the main data flow. If that Key has 1 distinct value, then rou...

Come on, this is now the third time you've posted this same error. Stick to one of your existing threads.

Not really a DataStage question and probably better places to ask your question. Perhaps someone here knows but in your shoes I'd look for a support forum for that product.

Why? There's no need to create a file that isn't needed nor a need to count all of the rows in it. The test Eric posted will tell you in a simple true/false manner if the file exists and is not empty, with true moving on to more complex tests and false causing a reject. If you need to differentiate ...

Nice, a Spinal Tap reference.

High level it means a mainframe file, typically generated by a COBOL program and that you process using the Complex Flat File stage. Hopefully you got more than that in your 'requirement'... an FD perhaps?