DSXchange

Hi Ray, Thanks a lot for the workaround! Although my job has finished successfully and generating the desired output but the sequencer is aborting with the same error for the 4th iteration. Since the output of your Exec command is generating a '|' delimiter at the end of the last record too hence th...

Line terminators are mapped to @FM. In your case you correctly (originally) specified comma as the delimiter. The problem is probably with the line terminators in your file. Can you please share how you are implementing "read each line of a file at a time"? Hi Ray, My design is like~ Star...

Hi Ray, The file has no new line at the end. I've also checked in the forum and it is recommended to use @FM, so I tried with this command~ Field(Execute_Command_0.$CommandOutput,@FM ,2, 1) but even then I'm getting the same error! Is it an incorrect command? Also can you please explain me why do we...

Hi All, I'm using execute command stage to read each line of a file at a time. The file looks like~ 3,123 4,456 2,677 Now when the sequencer runs for the first time, exec command reads the first line i.e 3,123. The value 3 is then passed to one of the job parameter A and the value 123 is assigned to...

Sorry my input file looks like this~ Bank_Name Cycle AccountNo State Status Balance ABC 1 123 NJ P 400 ABC 1 234 NJ P 789 ABC 1 888 NJ X 878 ABC 1 567 NJ C 678 ABC 1 789 NJ C 999 ABC 1 666 MI V 899 EFG 1 777 NA C 777 Thus even though row 3 was satisfying condition CA1 but it is not propagated in the...

I'm working on a very tricky requirement but I'm really not getting any idea on how to go about it. Here is the scenario~ Input File: Bank_Name Cycle AccountNo State Status Balance ABC 1 123 NJ P 400 ABC 1 234 NJ P 789 ABC 1 567 NJ X 678 ABC 1 567 NJ C 678 ABC 1 789 NJ C 999 ABC 1 666 MI V 899 EFG 1...