Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
TSO Command to remove the headers from a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
Ashley Justin Issac

New User


Joined: 14 Dec 2006
Posts: 1
Location: Chennai

PostPosted: Mon Dec 18, 2006 12:46 pm    Post subject: TSO Command to remove the headers from a file
Reply with quote

Hi,
Can anybody help me in finding the answers to the follwing questions

1. A report is generated and it is in a flat file.Using some TSO command I need to remove the Headers and Trailer and view only the records.

2. How can I hide a particular String In a program using any TSO command?

Thanks in Advance

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

sankar_MF

New User


Joined: 19 Sep 2006
Posts: 29

PostPosted: Mon Dec 18, 2006 3:30 pm    Post subject:
Reply with quote

Hi,

1. For the First case, you can use exclude command to remove the header and trailer.

In the Command Line, use the command X all 'string indentification of header/trailer and its position' and then issue "del all X " command.

For example if your header/trailer starts with the special characters '*'
you have to use the command as

X all '*' 1 and then (1 is the position the of the character "*")
del all X in the command line.

it will hide all the statements with "*" symbol in the 1st position.

2. For the second, i don't know the exact command. But if you replace the particular string by spaces, you can hide it.

C all "string" ' '

Please get me back if you have any concerns.

Thanks
Sankar
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Dec 19, 2006 12:49 am    Post subject:
Reply with quote

Just to make it clear: sankar_MF's suggestions contains ISPF edit commands, not TSO commands.

O.
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: Tue Dec 19, 2006 3:50 am    Post subject:
Reply with quote

Hello,

If you change the string from "thestring" to ' ' you have destroyed "thestring". It will no longer exist.

What kind of string do you need to hide?


If you want to exclude the headings, make sure the value you use can ONLY occur in the headings. Need to be sure not to delete any of the "records" just because they have a value that is typically in the heading(s).
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts How to change a string containing the... chong.zhou TSO/ISPF 6 Tue Aug 29, 2017 4:54 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us