DSXchange

sreddy wrote:Job status is Abort.

Understand that. Please tell us why it aborted, post the fatal error message(s) from the log.

So, do we have to guess what the "abort" is?

I'm not really sure what that means... can you rephrase the question, please?

So, you decided to post here although you have a completely different error / problem? Would be best if you started your own thread. With your own details.

Sorry Lance, much as I would love to help I have neither.

Will be interested in any answers, though.

Target stage please, Oracle Enterprise? If so, set to what Write Method? What data type are you using in the job itself for this field - Date or Timestamp? Can you post the generated SQL?

The more details you provide up front, the sooner we can stop dancing and get you to a proper solution.

Make an explicit conversion using the StringToDecimal() function.

You really should get yourself up on the latest 8.1.x release at your earliest oppurtunity. Perhaps this is it?

Show it to your Teradata DBA.

Before deciding where all this should come from, it would help to know what exactly it is that you need in this 'ETL report'. Do you? Can you articulate it here for us?

I have insert to table in format like 'dd/mm/yyyy' No, you don't. Unfortunately, if you think you do, that means you don't really understand DATE fields or how to work with them via SQL. What is your target stage? Is the SQL generated or user-defined? Those answers will help figure out what really ...

You can either go with a 'least common denominator' approach and use the lowest client version for all, or dynamically switch out the environment variables that control the Oracle client ($ORACLE_HOME, etc) on a job to job or project level to leverage multiple clients installed on the same box.

Ah... thanks for posting your solutions. :D

So... no comments in the code and nothing in the Short description? Nothing in the Long description to explain what it does, how to call it, known issues, change history, nada? If so, someone needs to be slapped around.

And you got an 'effective straight forward' answer in Ray's post. :? OK... first you need to ensure that you really need something in an external YYYY-MM-DD format for your date target. And since your source is already in that format (it just has some extra bits) if that's really what you need then ...