DSXchange

What Craig said, though you can nest the four Ereplace() function calls into a single expression.

Thank you for telling us that.

Did you have a question?

They are not. A composite operator occurs when one stage generates two (or, theoretically, more) operators, such as the Data Set stage generating one operator to delete the Data Set and another to populate it, when write mode is Overwrite. A combined operator (APT_CombinedOperatorController) occurs ...

Microsoft announces SQL Server on Linux.
https://blogs.microsoft.com/blog/2016/0 ... -on-linux/

Add the new server details correctly in the .odbc.ini file. Make sure that the new server DSN is mentioned in whichever uvodbc.config file you are using. Report any other logged error messages relating to this connection. Search SystemOut.log and/or SystemErr.log for more detailed diagnostic informa...

Try using VarChar for both columns when reading the text file (after all, a text file consists only of string), and introduce a Modify or Transformer stage to effect the data type conversions.

Can you please dump the job score to determine what the composite operator is?

It will certainly impact the machine on which the batch is running.

If you are importing into a separate project, then it should not greatly affect the running of the batch itself, unless the machine totally runs out of some resource (perhaps DataStage internal locks).

DataStage's understanding is governed by Precision and Scale. Precision is the total number of characters, while Scale is the number of fractional seconds.

A timestamp with no fractional digits is 19 characters long. Thus, for ten fractional digits, you really need 30,10 (not 22,10).

ASS is not necessarily salacious, for example when it refers to a quadruped beast of burden.

Can you verify that the Precision and Scale propertes are set to 22 and 10 respectively?

Perhaps this would be more easily solved using two Input Text Overrides to RETYPE the "offending" items to the NULL class (0), so that the rule set can properly process the remainder.

Does the "missing data" message come from the job log, or from your attempt to generate a job report? How are you attempting to generate the job report?

Welcome aboard.

Clearly something is different between DEV and Stage. You need to do the detective work to determine what that is.

Take a good look at the UP_IN_AMBIT_PRICE stored procedure. What exactly does it do? From the name, I'd expect it to have an input argument and an output argument but, without seeing its actual SQL, cannot be totally certain.