DSXchange

Hi, Is there any way to fetch the list of all the jobs that has been invoked by a specific Invocation Id. Example: Job X - Invocation Id 1 Job Y - Invocation Id 1 Job Z- Invocation Id 1 So, i need to find the list of all the jobs whose Invocation Id is 1, that is, Job X, Job Y and Job Z. Thanks

If I have to use EVAL where do i use it?

Thanks

The If Else statement is prepared by reading a Table. The number of ranges vary. Today the number of ranges can be 5, tomorrow 6 etc. So, using a Unix script, i prepare this Statement and Pass it to the Job. But, i was not sccessful of what i thought.

Any Ideas?

Thanks.

I have prepared an Expression via Unix script (dynamic in nature based on the number of records in a table that drives the expression) that needs to be used in the Transformer Stage of a job. This expression does not return the result that i am looking for, instead, just outputs the expression itsel...

Hi, I am reposting this message since i did not get any responses. I am facing 2 problems. 1. I have created few Parallel Shared Containers. In Parallel Stages that are used in these Shared Containers, the Configuration file property is empty and, next to it i see the message - Warning: No configura...

Hi, I am facing 2 problems. 1. I have created few Parallel Shared Containers. In Parallel Stages that are used in these Shared Containers, the Configuration file property is empty and, next to it i see the message - Warning: No configuration file set. But the jobs that use these Shared Containers co...

Our Dev environment is on 7.5.2 and UAT is on 7.5 I have a job that compiles and runs successfully in Dev and Fails to even Compile in UAT. The following is the Compilation error that is showing up at PX Transformer. Output from transformer compilation follows: ##I TFCN 000001 14:55:42(000) <main_pr...

Also, the next time the job ran with teh same source file, it finished successfully.

That is not the case.
There are 5 Key fields in the Hash file. All the fields have Values as per the Record.

ds_uvput() - Write failed for record id 'FNAA3070B
1
-70001
2007-07-03
9999-01-01 00:00:00.000000'

While DataStage server was running, the job aborted due to the following Fatal error. The job reads a Sequential file and writes to a Hash file. stg_SUMRY_HST_ins: ds_uvput() - Write failed for record id 'FNAA3070B 1 -70001 2007-07-03 9999-01-01 00:00:00.000000' The job successfully finished in the ...

I use a Routine to Round Decimal values. The code is as follows Value and Digits are the paameters passed to the routine If Digits > 0 then Ans = FIX(Value, Digits) End Else Ans = FIX(Value/100,50)*100 End I also tried PRECISION 14 If Digits > 0 then Ans = FIX(Value, Digits) End Else Ans = FIX(Value...

I am not able to see the full contents of the reply that Ken and Ray posted.

Compare does not work in a situation where the args compared are numbers like 2335567.7700000000 and 2335567.77

PRECISION 14 DataIn1 = TRIM(Arg1) DataIn2 = TRIM(Arg2) If (IsNull(DataIn1) and Not(IsNull(DataIn2))) or (IsNull(DataIn2) and Not(IsNull(DataIn1))) Then Ans = @TRUE End Else If IsNull(DataIn1) and IsNull(DataIn2) Then Ans = @FALSE End Else If (Not(NUM(DataIn1)) and NUM(DataIn2)) Or (Not(NUM(DataIn2)...

Using the following code throws Phantom Warning. The content of the Warning is Program "DSU.FMDifferentExtd": Line 21, Nonnumeric data when numeric required. Zero used. Program "DSU.FMDifferentExtd": Line 21, Nonnumeric data when numeric required. Zero used. Program "DSU.FMD...