DSXchange

Hi, Job is giving below warning and Fatal error"xxx_Tfm,1: sh: dbx: not found". xxx_Tfm,0: Operator terminated abnormally: received signal SIGSEGV But job is still in running condition. Sorry,the issue is not with long constraint. As suggested I tried to use stage variable for trimming rig...

Hi, Below is the sample transformer constraint which is stays running state in datastage 8.5. ((PARAMETER1='EOD' or PARAMETER1='ME') And RIGHT(IN_LINK.COLUMN1,3)='EOD' ) OR (PARAMETER1='SOD' And RIGHT(IN_LINK.COLUMN1,3)='SOD') OR ((PARAMETER1='ID1' or PARAMETER1='ID2') And RIGHT(IN_LINK.COLUMN1,3)<>...

In Screen shot , RMVDUP_UP_HIER stage (Remove duplicate stage) has different out put. So check the partition in remove duplicate stage.

Check it out. If Trim(NullToEmpty(Ln_in.col_2))<>"" Then StringToDate(Ln_in.col_2,"%yyyy%mm%dd") else SetNull() .Simple..

Add jar file into /<server>/etl/InformationServer/Server/DSEngine/java/lib/tr4j.jar class path.

Thanks
Jose

What I used to do is Hash partitioning on Sort stage and same partitioning on join stage input links. Partitioning key you can give same as joining key. So you will get matching data in one partition.

Outer join link data column can be given as nullable "Yes" then in downstream stages null can be identified by isnull() or Trim(NullToEmpty(Column name))<>"" functions.

Hi, For below deadlock situation datastage job not got aborted but it send a warning only. sybase stage is using and treat error as non fatal check box in output->SQL->before and after is ticked. Is it due to this job not aborted. Or Some setting problem in DB. How to make datastage job abort in thi...