IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

TSO Command to remove the headers from a file


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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
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: 2358
Location: Israel

PostPosted: Tue Dec 19, 2006 12:49 am
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

Moderator Emeritus


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

PostPosted: Tue Dec 19, 2006 3:50 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts RACF - Rebuild SETROPTS command which... All Other Mainframe Topics 3
Search our Forums:

Back to Top