DSXchange

If you meant you're not getting which command to use, that depends entirely on what you are trying to accomplish but you can pick from any available O/S command.

For the first question, I'd look into the dssearch command. For the second one, the various DSGet functions like DSGetJobInfo, DSGetStageInfo, etc, or their command line dsjob equivalent ... I couldn't find this command in my system. (my DataStage is 7.5 on Windows) I ran a search even. something h...

You are in for a world of hurt if you plan on having your Enterprise scheduling tool running hundreds or thousands of individual jobs, enforcing dependencies, error handling, restarts and the like. :shock: If you've got nothing else, there is no disadvantage to sequence jobs and their restartability...

A hint? Send data to it. Better yet, read this and all will be revealed.

Have you tried searching for "Fault type is 11. Layer type is BASIC run machine." yet? It turns up several matches. It may also help to fully describe your job.

Pretty normal stuff, make sure your numbers are numbers and your delimiter doesn't occur in your data regardless of what it is.

Search here for USERSTATUS and the SetUserStatus routine you can write to leverage it. Sequence jobs can easily pull information from this and pass it to other jobs and/or control the job flow with it.

Perhaps there's another istool patch to fix that?

True, as what was described is not your typical 'surrogate key' which by definition is not derived from application data.

In other words, there's no built-in stage for this.

Negative sqlcode values equate to 'positive' ORA errors, so SQLCODE=-1 equates to ORA-00001 or DUP_VAL_ON_INDEX:

Your INSERT or UPDATE statement attempted to store duplicate values in a column or columns in a row which is restricted by a unique index.

OK, now that that's out of the way... this looks like simple concatenation to me. Stick the month, zero padded, onto the year and then "01" after that. Have you tried anything along those lines? What issues did you have?

Set the value as 'OPTIONS(DIRECT=FALSE,PARALLEL=FALSE)'

Wow... a reference back to the 1700s, fitting somehow. And I love how it starts out - I don't mean to hijack this, but... [whips out pistol] fly this plane to Cuba! Oh, and could you answer this DataStage question while we're in the air?

This forum is for discussion of possible FAQ topics. Please repost your question in either the Server or PX/EE forums depending on the job type.

[*Topic relocated per request - Andy*]