Hello,
I'm trying set up a automate batch job to read the Fixed legth .TXT file from Shared drive and load into AS400. And then the program reads that file and do some process.
When ever i'm running that job there is one decimal field in that file and once the file is read it's throwing all the junk data into the Numeric decimal field, because of that data is getting jumbled in the next fields.
File layout is in Attached file layout.txt and my FTP job is in FTP job
Trying to load TEST.txt from shared directory (as400-connector)into PRAEDB/pfpupconn using GET command in PUPCONCMD.
Attached CL,File Layout, Input test file and Output Error file snapshot. Can some one help what is the problem in this, when I do that manually through 'Receive file from host' in AS400, all the fields are getting loaded properly with the same input file. I feel some issue with the Absence numeric decial field.
Appreciate the response.
Thanks,
Anil.
I'm trying set up a automate batch job to read the Fixed legth .TXT file from Shared drive and load into AS400. And then the program reads that file and do some process.
When ever i'm running that job there is one decimal field in that file and once the file is read it's throwing all the junk data into the Numeric decimal field, because of that data is getting jumbled in the next fields.
File layout is in Attached file layout.txt and my FTP job is in FTP job
Trying to load TEST.txt from shared directory (as400-connector)into PRAEDB/pfpupconn using GET command in PUPCONCMD.
Attached CL,File Layout, Input test file and Output Error file snapshot. Can some one help what is the problem in this, when I do that manually through 'Receive file from host' in AS400, all the fields are getting loaded properly with the same input file. I feel some issue with the Absence numeric decial field.
Appreciate the response.
Thanks,
Anil.
Comment