DSXchange

Domain masks relate to preprocessor rule sets and indicate the domain-specific rule set to which a particular token should be sent for processing. The only legal values are: A address N name R area O other For example, A in KRPREP indicates that the token will be analyzed by the KRADDR rule set. Ref...

POST actions are the post-execution actions are those actions which should be executed after the pattern matching process is finished for the input record. Post-execution actions can include computing Soundex codes, NYSIIS codes, reverse Soundex codes, reverse NYSIIS codes, copying, concatenating, a...

Two wrongs don't make a right. But three lefts do.

Brave call.

Just because the same symptom occurs does not necessarily mean that the cause is the same. Just ask your doctor.

You're probably not executing in the same directory. Include a cd command in the commands executed from DataStage.

You need to add five months then add two days, perhaps in two stage variables in the Transformer stage. This requirement can not be done as a single generic function because month lengths are unequal. Is there anything special about "five months and two days" (just curious) or is this a specific exa...

Welcome aboard. U (one of our participants) does not log in all that often, so it might be some time before U can tell you anything. Also, we do not hijack threads: please post a new topic in this forum.

Then become a premium member.

What invocation ID did you give in each case?

What error?

It can only be done if the job is capable of running multiple instances (this is a compilation option set in job properties). If the job is not capable of running multiple instances then the second attempt to start it will fail with a "job not in correct state" error, meaning that it is already runn...

Suggestion: buy a premium membership so you can read my suggestions. The answer is, I believe, in those parts of the answer that you can not see.

Had you had a premium membership you could have read the entirety of my previous reply. I proposed some ideas in that post. How long does this query take to return all rows (note: NOT to return the first row) using some other client, such as TOAD? Why do you think DataStage would be any different? Y...

If you write custom queries you're pretty much on your own. Why aren't you using generated query? A SELECT statement can never generate UNIQUE constraint violations. I suspect you're not managing your keys very well either. How many jobs call KeyMgtGetNextValue with an argument of 1? An excellent wa...

Get your head around this idea. A date is a date is a date. Inside Oracle (or any other database, pretty much) it is stored as a binary value. Different tools have different requirements and standards as to how the date should be represented for human consumption. Usually these are configurable (for...

If you want alphbetic month characters you have to specify the same. One way to do this is: Oconv(Iconv(Left(Inlink.Field1,10),'DYMD[4,2,2]'),'D-DMY[2,A3,2]') Another way is Oconv(Iconv(Left(Inlink.Field1,10),'DYMD[4,2,2]'),'D2-DMBY') Don't use Substri...