DSXchange

There are basically 3 output links from the Transformer based on the below constraint: Output1: (lnkRecsOut.leftRec_BRANCH_NUM <>"" and lnkRecsOut.rightRec_BRANCH_NUM<>"") Output2: lnkRecsOut.rightRec_BRANCH_NUM = "" Output3: lnkRecsOut.leftRec_BRANCH_NUM = ""...

I have developed a job which reads from two sequential files and performs a full outer join. The output of the join stage goes thru a Transformer where data is split into 3 output files based on certain criteria. While running the job the job abends and gives the below error message tfpAddrrec,0: Op...

Hi, I removed the precision column and defined the fields as just DATE in the SQL type.But while compiling I got the below error. ##E TCOS 000003 04:22:57(001) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "LEAD_START_DATE": The schem...

Hi, I am facing a problem while mapping two date fields in the Transformer. The Date fields LEAD_START_DATE and LEAD_EXPIRY_DATE have been defined as DATE 10. In the Transformer I'm moving these fields into two other date fields which are defined as DATE10. But while compiling the job i get the belo...

Hi,


I tried using %yyyy-%mm-%dd option but the job aborted while running.


Thanks,
Bhavna

The entire error message is posted below: main_program: Error parsing modify adapter: Error in binding: Unknown conversion: StringToDate; input: (LEAD_START_DATE=StringToDate(LEAD_START_DATE,"%yyyy%mm%dd") ; Also I tried using the date_from_string(string) function which converts the string...

Hi, I need to convert the date which is in the form 20050202 to 2005-02-02. I tried using the Modify stage in order to acheive this and gave the following derivation in the modify stage:LEAD_START_DATE=StringToDate(LEAD_START_DATE,"%yyyy%mm%dd") Compilation was successful but the job abort...