Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Selecting records from a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
Amit Manas Dubey
Currently Banned

New User


Joined: 15 Dec 2006
Posts: 22
Location: Mumbai

PostPosted: Tue Sep 04, 2007 10:21 pm    Post subject: Selecting records from a file
Reply with quote

I have a file which has a no of reports in a sequential format. The start of the report can be identified with the String 'D21' which is the name of the report.

I want to download this report and want to ignore the other reports which are present in the same dataset.

The Dataset is so huge, that I cannot open it in the Edit mode.

Can you pls advise as to how can I select all the records in the file after the start of the D21 report ?

Regards,
Amit.
Back to top
View user's profile Send private message

Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Tue Sep 04, 2007 10:46 pm    Post subject: Reply to: Selecting records from a file
Reply with quote

Quote:

Can you pls advise as to how can I select all the records in the file after the start of the D21 report ?


Do you want to select only the records of the D21 report or all the records after D21 report?
Back to top
View user's profile Send private message
Amit Manas Dubey
Currently Banned

New User


Joined: 15 Dec 2006
Posts: 22
Location: Mumbai

PostPosted: Tue Sep 04, 2007 10:47 pm    Post subject:
Reply with quote

I want to select only the records of the D21 report.

Regards,
Amit.
Back to top
View user's profile Send private message
Mickeydusaor

Active User


Joined: 24 May 2006
Posts: 258
Location: Salem, Oregon

PostPosted: Tue Sep 04, 2007 11:49 pm    Post subject:
Reply with quote

You can use VIEW and copy the lines you want into another dataset
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Sep 05, 2007 12:05 am    Post subject: Re: Selecting records from a file
Reply with quote

Amit Manas Dubey wrote:
I have a file which has a no of reports in a sequential format. The start of the report can be identified with the String 'D21' which is the name of the report.

I want to download this report and want to ignore the other reports which are present in the same dataset.

The Dataset is so huge, that I cannot open it in the Edit mode.

Can you pls advise as to how can I select all the records in the file after the start of the D21 report ?

Regards,
Amit.


If you would provide the particulars about your file, RECFM, LRECL, location of the report ID (D21) and how to identify the end of the report (or the beginning of the next report) and post this in the DFSORT area I'm sure someone will be able to provide a solution.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Sep 05, 2007 12:13 am    Post subject:
Reply with quote

Hello,

If D21 will not always be the last report in the file, you need to post how to identify the end of the D21 report.

You might also mention what should happen if there is no D21 report in the file being processed.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us