DSXchange

Thanks a lot for directing me with the valuable source of information. I am not able to see the Record Type="implicit" option in the Complex flat file stage properties under File options tab. (DS version 8.5). I could only select the below options as Record type; Fixed, Fixed Block, Variab...

Hi, Thanks for your response. In the current job, I am not doing any transformations using the Transformer so I am just trying to extract the data (Which is in EBCDIC BINARY)using complex flat file stage and load (ASCII data)to sequntial files. Yes, I am giving the correct length as per the file see...

Hi, Thanks for your response! I have even tried with double quotes for the record Id values but still the job is getting aborted with the below warnings/errors. Warnings: Complex_Flat_File_0,0: Field "complex_flat_file_0_record_type.DETAIL.ACT_NO" has import error and no default value; dat...

Hi There, I have a problem while reading multiple record types using Complex Flat file. My input file is coming from Mainframes in EBCDIC (Binary) format and it has three record types in it; Header, Detail and Trailer. I have defined three record definitions in CFF stage along with the Record Id spe...

Hello, I have a job that upserts records through oracle enterprise stage to a oracle table. Initially, i have the job tested successfully with all the records inserted or updated. But, after a week time when i test the jobs again the job is running forever with the same input file. Its not generatin...