DSXchange

Glad you got it figured out... maybe I'm thinking of how you would handle it in the Server world. Or maybe I'm just delusional.

I *believe* you can change "mmm" to "MMM" to achieve that.

OK, I only asked because you said "One of job is changing from complied status to not complied status every day". This sounds like someone is opening (and thus locking) a job in Designer and then either leaving it that way or disconnecting rather than closing it properly. Not sure how one ...

Until the next day when the process repeats?

Where / when are you seeing this error?

Several ways, all of which have been discussed here ad nauseam. Classic answer is for you to go to Kim Duke's website and download his free ETLStats package. It does that and a crap-ton more... take what you need from it or leverage the whole package. Nowadays that kind of metadata is collected by D...

Why would 'many columns' stop you from using a Transformer? It may be a little bit of drudgery to set up but it's not like it won't work. Out of curiosity, how many record types do you have?

You do understand a Build Op requires you code it in C++, yes? Do you have that skill in-house?

You can't use I/OConv as they are Server functions. You should be able to use StringToTimestamp however are you certain you need it in 12 hour AM/PM format?

Sorry, should have been more specific - that suppresses the message but as noted you still have to handle the non-zero return status rather than leave it "unhandled". That's an option you turned on in the Sequence job and you can override that behaviour by handling the error yourself. Simp...

No problem, here we are in the proper forum.

Can you answer the NLS and characterset questions, please? And clarify the exact version of DataStage you are running. Thanks.

Let's start by getting you to your own post.

Sorry but I for one am not really sure what your question / issue is. Are you saying that (for the example data posted) sometimes the output is as posted and other times what ends up in Property_1 isn't 'Name' but one of the other values? If so, let's clarify some things. What is your source and how...

Typically one would redirect standard error to /dev/null.

So is this actually a Server job or a Parallel job? Since you mentioned EReplace (and we're in the Server forum) I suspect the former but you marked the Job Type as Parallel and could be in the 9.x world. And it would seem you don't have a stored procedure call issue, just an NLS translation one. So...