DSXchange

Thank you for sharing that.

Most of those here who use Oracle are aware of the default date format picture.

So write one.

Is it even possible to delete a job from Director?

The DataStage operator role, as mentioned, would not have delete rights.

I'd prefer to use the system variable @OUTROWNUM, particularly if you're using a constraint expression on the output.

How many times are you going to ask this question?

Just because it's about repetition elements there's no need to indulge in repetition questioning.

No. Auto-purge is not as automatic as the name suggests. It is triggered by successful completion of the job. So, even if auto-purge is set to 3 days (for example) the job log will not be purged until next time the job is completed successfully (without aborting), no matter when this is. You would n...

They are not used for server jobs.

The first disables use of the project (or named) message handler, the second disables use of local (or job) message handler for parallel jobs.

If it's only one particular value or pattern, a rule set override may be easier than customizing the rule set itself.

Hhow can i increase the performance of the jobs(number of rows from hash file to transformer) ?? The only way that you can increase the number of rows is by increasing the number of rows (that is, by reading more rows). The execution environment for version 8 is somewhat different to the execution ...

USER_INFO is the text that you supply as the routine argument. JOB, STAGE and LINK are added by the code.

Source code for these SDK routines is supplied - you can inspect it in your Repository. The branch is sdk\Utility.

Ur was a city in ancient Babylonia. The second person personal pronoun in its possesive form is spelled "your" in English. Please strive for a professional standard of written English on DSXchange. You would not use SMS-style abbreviations in your formal work documentation, would you? You are commu...

Do you mean, by "record delimiter":

(a) the character that marks the end of the record (the record delimiter)?

(b) a character that appears between the final field and the record delimiter (the final delimiter)?

(c) the character that separates fields within the record (the field delimiter)?

Think JOIN STAGE

You can't have a timestamp without a date component. What date do you want to use for the date component?

That's like asking why two production cars perform differently. There's not enough information. Seek out the difference(s) between the two projects.