DSXchange

So you're just asking how to do a Type 2 change? Meaning, a new record is inserted for the effective date of the change and the original / old record is closed / marked as no longer current in some fashion. You must be checking for existence already so you know whether this is a new or changed recor...

I'd also be curious if this used to work and stopped working, or if this is a brand new install and it has never worked.

Why don't we start with words. You need to upload whatever image you are trying to include in your post to a file sharing site and then use image tags to include it in your post. No one except you can see an image on your PC.

So, use a Server job or from what I've read there is a PX version somewhere in the 9.x release. There's also a pxEReplace posted here which may or may not be problematical, an exact search should turn it (and the discussion of it) up.

No, Convert supports single character substitutions. You'd need a version of EReplace for that.

So... did you actually confirm your kernel settings were appropriate? Hard to know for certain when you make a blanket statement like that. I'd also be curious if you compared them between the two "same OS" environments. And pretty much every discussion here of the MEMOFF settings notes th...

premupdate wrote:Sequential file Options: Enabled first line is column name to true.

That option causes the headers to be skipped, turn it off so the header record just flows through as data.

An additional problem. Even once working, the base problem will still be the fact that a count of 1 will be considered an 'unhandled failure' with that option turned on unless the sequence job thinks you are handling the failure. And how you do that is documented in the same place that option is.

That's it, conflated. Definitely... conflated. Yah.

swapna07 wrote:But when I am trying to run the seq, it is aborting with error as below :
Command wc -l did not finish OK, reply = '1'
Unhandled failure (1) encountered executing command wc -l

Hence my reply.

That's because it's not SQL. Where/how would you run it without DataStage?

Not confused... which is why I specifically noted I was making a general statement.

Mind the forum and job type, Ray.

Andrea, he's thinking you're running a PX job.

Do an exact search here for "Unhandled failure"... you have the Automatically Handle option on and your command did not return zero. That = failure.

I'd double-check that your kernel settings are in line with what the new version and platform expects. I would also suggest a small sleep between the reset and the run, in my experience it can sometimes take a moment for the reset to actually finish up post-return and we had some odd errors before w...