DSXchange

Cannot be done in a single job.

TonyInFrance wrote:I don't think screenshots are possible on this forum...so you aren't missing anything...

They are.

As in most forums, they are just [img] (Image) tags pointing to a file at a hosting site.

sreesuku2 wrote:I am sure, I had saved these jobs, compiled and executed before the services restart.

Me... not sure at all. There's no way for them to revert back to a state before your change unless you didn't actually save them.

Or just pre-create the table before the first run. Not sure anything else makes sense. You don't want to setup something you have to remember to change after the first run. Or be dropping and rebuilding a table when (I imagine) a simple truncate would suffice. And unless I am mis-remembering, that &...

Exactly... doesn't change the answer.

Have you asked your DBA? Or your support provider? I've only seen mention of that error when hitting an 8i instance and typically that over a dblink, I'm guessing neither of those are the case here so it could be a bug in the stage or perhaps in the Oracle client.

Exactly. Was hoping that would have been inferred from the first answer.

Do you have a column defined named LOC_NEW?

... and then "I'm feeling much better!".

Seems like a good thing to put in front of your official support provider for clarification.

I'd also be curious if this was working and then stopped or are you are trying to get it to work for the first time?

It's still invalid syntax and is not "working correctly", nor is there a need to check lengths. Sorry but this is pretty basic stuff, did you check the documentation for the function? Using that StringToDate function inside IsValid is the problem as it is far too early. Check validity, the...

Involve your DBA. I too would suspect a tnsnames.ora issue of some kind.

That 'best way' would be via the Row Count option in the stage. In case it's not obvious yet, I do not know why it is disabled when you have multiple links coming into the stage and couldn't find it documented anywhere. Not having access to DataStage means I've been hoping someone else will come alo...

ssnegi wrote:if IsValid('Date',StringToDate(DSLink.DT,"%yyyy-%mm-%dd"),"%yyyy-%mm-%dd") then DSLink.DT else SetNull()

Sorry but that's not valid "IsValid" syntax. You use it to test a string value before attempting to convert it.