Extract

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
pawan.konduru
Member
Posts: 12
Joined: Mon Feb 17, 2014 11:35 am
Location: Hyderabad

Extract

Post by pawan.konduru » Tue Feb 09, 2016 2:31 am

Hi,
can someone do the needful,

I have a file with the below inforamtion, i need to extract the 4 lines from the file when the Pos: 4 to 6 bytes of line 1 have the value G1151C and a value 000-59929 in Line-3 Pos 1 9

1 xxxG1151C
2 034
3 000-59929
4 9896.00
1 xxx G1151B
2 0565
3 000-58053
4 1235.00
1 xxxG1151C
2 025
3 000-59111
4 3659.00
1 xxxG115C
2 000
3 000-59929
4 123.55

o/p should be
1 xxxG1151C
2 034
3 000-59929
4 9896.00
1 xxxG115C
2 000
3 000-59929
4 123.55

Can this be possible in Sort/Sync Sort.
Pawan K

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Tue Feb 09, 2016 2:39 pm

What is the LRECL and RECFM?

pawan.konduru
Member
Posts: 12
Joined: Mon Feb 17, 2014 11:35 am
Location: Hyderabad

Post by pawan.konduru » Thu Feb 11, 2016 12:27 am

RECL=80, RECFM=FB
Pawan K

Post Reply

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



Other References
Mainframe Tools and others