DSXchange

Biggest problem? Trying to use sqlplus to connect to Teradata. That would be for Oracle, sorry no clue what the Teradata equivalent would be but it ain't that.

As noted, the answer will depend on your definition of 'month' when computing the number of months between dates. If your definition aligns with Ray's then you're all set.

yousuff1710 wrote:Use function DaysSinceFromDate & then divide by 30.

Not in a Server job.

To be certain, view the file outside of DataStage (say, with 'vi'), what do you see for that column? If it is bad there then your transformation is failing.

Use the Contact link at the top of the page and send an email to the Webmaster.

Your metadata defined in the Sequential stage does not match the actual file's data. Details please - how many columns did you define? What column delimiter? Etc.

The column name you use in the job has no bearing how the SQL is prepared / executed except when creating tables from that metadata, it is strictly positional for DML. That :1 bind parameter denotes the value from the first column defined in the stage, irrespective of its name. So your change should...

When you don't get any answers, best to just reply to your original post to 'bump' it back up into the limelight rather than post the exact same question again.

Sounds like this 'other server' either isn't properly configured for Oracle access or doesn't have that entry in its local tnsnames.ora file.

What the heck does 'deleted the job logs' mean?

Sorry, finally paid closer attention to your actual SQL and see it is an update. For some reason got select in my brain, which means this would all have to come into the job as a job parameter. Now that that's out of the way... Since you know they are numeric values why not just strip the surroundin...

Me like.

Welcome! No, there's no single command - you need hand code and knowledge of the underlying structures for that. Fortunately, Ken Bland has already done the dirty deed for us.

Logs? No.

Sorry, missed that. Yes, much as one would expect, only the person who owns the lock or the admin / superuser / dsadm account can perform this action.