Hello Guys
I have a vsam file in which I have some invalid fields for some of the records, however I am not sure about the values of those fields(defined in PS format). I am extracting that file into flat file. but while doing extraction I want to find all those fields and replace with 0 or spaces.
Can anyone help me to do this by providing code for this.
Sort or DFSORT - find all those fields and replace with 0
Moderators: Frank Yaeger, Moderator Group
-
- Member
- Posts: 29
- Joined: Tue Feb 18, 2014 9:13 pm
-
- Member
- Posts: 29
- Joined: Tue Feb 18, 2014 9:13 pm
I have a VSAM file in which a field is defined as a character field and then it got redefined in PS field. When I am trying to extract that field in flat file, it is throwing SOC7 error as there are some value which are not numeric So I just want to remove those values. Those values can be different,
What is a "PS field"? Whatever, when it was redefined a conversion program should have been riun to convert the data from the old format to the new format. And a S0C7 was not "thrown". DFSort, Rexx, Pl/1, COBOL etcs do not "throw" errors - they abend or fail with an S0C7 or whatever. Throw is for "curly-wurlt" languages i.e. those that use {} and throw and catch exceptions (note: not errors).
Regards
Nic
Nic
-
- Member
- Posts: 29
- Joined: Tue Feb 18, 2014 9:13 pm
You are going to need to post some fo the values in hex and then explain what to do with the different values in the field(s).
Your description does not use "normal" terminology. This is terminology that has come into use in your organization?
What you is completely clear to you, but it is not to the rest of us. Someone might make a lucky guess, but it is better for the info to be posted.
Your description does not use "normal" terminology. This is terminology that has come into use in your organization?
What you is completely clear to you, but it is not to the rest of us. Someone might make a lucky guess, but it is better for the info to be posted.
Have a good one
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