DSXchange

Sometimes? And 'sometimes' it works?

What do the times where it does not work have in common?

What error? You should be able to set Write Method to Load and Write Mode to Truncate in the OE stage to do this, unless there is more here than you are telling us.

Need to? No. 'Force' means to always include it in the job, otherwise it is included or 'optimized out' at its discretion.

Yet another reason to avoid custom / user defined sql unless you have no other choice.

reachmexyz wrote:

chulett wrote:IDENT1 is an "invisible" transformer (active) stage it is adding between your two passive stages. This is a PX job? I thought it only did that for Server jobs.

No this is a server job. Not Parallel

You marked the Job Type as Parallel, hence the confusion.

IDENT1 is an "invisible" transformer (active) stage it is adding between your two passive stages. This is a PX job? I thought it only did that for Server jobs.

A search of the forums for "Exporting nullable field without null handling properties" would turn up a plethora of examples, seeing as how you're not the first to ask this question.

Are any additional messages logged when you Reset the aborted job?

Any parameter not metioned will take its default value, not ealier if by "earlier" means the overrides you passed at the command line in the last run.

Broken formatting tag, ignore it. Should have looked like this:

As a PX newbie (who finally has access to the product) can some kind soul put into words for me the next effect of this change, please?

That option runs the job and tell it two things - to wait for the job to complete before releasing the command and to return the DataStage job status rather than a UNIX status. Meaning 1 = ran ok rather than zero.

Aborting how?

In other words, you simply create and populate the appropriate job parameter and then use it in the Invocation ID box in the Job Activity stage rather than you hard-coded value. This box only appears for MI jobs and you seem to know which that is.

All of which, and more, is "out there" if one searches as suggested. Sure, you get 148 matches (today) to go through, but it's all out there.