DSXchange

It seems your lookup is failing and so it is returning a null . Try changing nullable as yes for COLUMN_NM_1 ,COLUMN_NM_2

One method is to export all jobs into xml and create a job which reads this file to get the sequence name and job names. we may need to try this out

oops , yes you are right , If the value is null we should set that to null else the expression .I guess the problem is because of arithmetic operation with a null value

Thanks ray

You may use job start timestamp or end time stamp with the job name for this

Can try modify the expression as

IF IsNull(DSLink3.F1) then DSLink3.F1+5 else SetNull()

which will handle null values .

In Case there is no space between double quotes , is the value after the trim is going to be null

I was trying to use trim function on a variable which has spaces . It seems it does not return a null . Any suggestion on the function to be used for the issue , so that it should return a null if the values is spaces

Can you try reading the numeric value to varchar 13 and then convert it back to integer

Hi Ray ,

We could force to run the lookup stage run sequentially , which would avoid any issues due to parallelism . let me know your comments on that

I guess some of the link variables has value as NULL . Can you replace the null with some value and try out.

Look into Sql loader log in Scratch directory , which should give some clue to resolve it

Is the next job activity independent in the sequencer ?

try Field(in.Col, " ",1) in place of Field(in.Col, "0:00:00 ",1) as suggested by dsguru

Try extracting using string function the date portion from timestamp , since leanth of the date portion varies depending whether its a 1 digit day or month

I am not sure whether its is a good approach to use oracle sequence for generating sequence since for each incoming record there will be a database call right ? .I prefer doing doing it within datastage for performance reasons