DSXchange

If you are not contsrained with using just a single job
then preferable solution would be writing values in some intermediate dataset in JOB 1

and in JOB 2 , Intermediate dataset data can be appended to Required dataset.

Hi All, I am trying to compile my job but it says "An unidentified error has occured" when I clicked on show error button its pointing to Lookup stage in which I am looking up on two fields and making a reject link if lookup failure and writing the rejects to a sequential file. I tried to...

Try converting your sort / partition keys to not nullable and then try once.

- better to run updates if any, in serial mode
OR
- Perform inserts and updates in 2 different jobs
OR
-Possibly Hash partitioned data before load might help as well in avoiding parallel updates

Try using FIELD function with delimiter string as "TS"

Lather you can concatenate 2nd part of your string for the concatenation
Ex.
Link.Column[1,2]:FIELD[Link.Column,"TS",2]

Let me know if it works out...

Could you make sure if the input column passed to the modify is not nullable.

- Could you cast the source column to varchar / date and try extracting ?

Simply assign the value to a stage variable with type VARCHAR(2) and use it in the output column of type VARCHAR(2) with trim function

In fact try assigning your string value to a decimal type stage variable....
Datastage would implicitly handle it.

You may try DecimalToDecimal() In the stage variables and assign the variable value to the column

By default it should insert both the records.

- Make sure you are not setting unique constraint / key constraint on columns which might avoid duplicates

Have you used Sort + Aggregate in the job before load operation