Hi All,
I have an input file which has a field "amount" from the column 25 to 34.
If the amount field is having space, job abends. In that case we have to strip that record and run the job...
Please suggest me something so that this abend can be prevented.
Can i use sort utility and sort the file in ascending order with the sort fields 25 to 30. And check if the particular column is space replace it with zero. Can i achieve this with JCL only.
Thanks.
to remove space from the amount field.
Moderators: Frank Yaeger, Moderator Group
-
- Member
- Posts: 2
- Joined: Tue Jan 20, 2015 2:55 pm
-
- Active Member
- Posts: 732
- Joined: Thu May 24, 2012 4:07 am
-
- Member
- Posts: 2
- Joined: Tue Jan 20, 2015 2:55 pm
Thanks Collins...
That bad data will come that way only beacause it is coming from an online upstream. And that is not bad data if the amount is zero they leave it blank... we just have to change it to zero.
Yes, i understand that i can not do any thing with using JCL only...
My ques was is there any utility by which i can sort the file and the replace those balnks with zeros.
That bad data will come that way only beacause it is coming from an online upstream. And that is not bad data if the amount is zero they leave it blank... we just have to change it to zero.
Yes, i understand that i can not do any thing with using JCL only...
My ques was is there any utility by which i can sort the file and the replace those balnks with zeros.
Anant
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page