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
 

 

Get the selected columns in a file by using file-aid tool

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
senthilkumar selvaraju

New User


Joined: 30 May 2005
Posts: 16

PostPosted: Tue May 31, 2005 4:58 pm    Post subject: Get the selected columns in a file by using file-aid tool
Reply with quote

Is it possible to get the selected columns in a file by using file-aid tool
Back to top
View user's profile Send private message

jkbytes

Active User


Joined: 19 Feb 2005
Posts: 141
Location: South Africa

PostPosted: Tue May 31, 2005 5:38 pm    Post subject: Re: file-aid
Reply with quote

Hi,

In File-Aid batch

The VPRINT function prints records in vertical formatted mode, presenting the
data according to a COBOL or PL/I record layout like the vertical formatted
display of online File-AID Browse or Edit.
The VPRINT report output width is 132 characters. The report format includes
spaces separating the fields. When the VPRINT output exceeds the report width,
File-AID writes the VPRINT DATA TRUNCATION informational message, VP001-Data
truncation occurred while processing VPRINT request to the SYSPRINT log. Use the
FIELDS parameter to specify which fields to include in the VPRINT output
Back to top
View user's profile Send private message
kanak

Moderator


Joined: 12 Mar 2005
Posts: 252
Location: India

PostPosted: Tue May 31, 2005 6:02 pm    Post subject:
Reply with quote

One way is you display all the column and then hide the column you don't want. Fir that use 'HIDE' command which will give you list of all the columns and put x which you want to hide. You can get it back by again issuing hide command then put R for the columns you have hided.
YOu can use one more way i.e. use command DISPLAY <from col no - to col number> OFF.
Yuo can get it back by DISPLAY <from col no - to col number> ON.

You can try one thing that while giving the layout for a particular file, in the layout file try to keep only those field you need, rest of the of the them give as FILLER.
Though it is the most crude method i believe...hope this help you..
if you have any more concerns let us know..
correct me if i m wrong....
Back to top
View user's profile Send private message
eashwar

New User


Joined: 21 May 2005
Posts: 26
Location: Bangalore

PostPosted: Tue May 31, 2005 6:05 pm    Post subject: Re: file-aid
Reply with quote

Hi
yue can copy whole member'
yoe can copy a part of a member
what ever you can do with tso commands that can be best accomplished using file aid tool, file aid is just an extension to tso commands to do with ease

for y r question
use copy command as you use in tso

place line commands
a/aa/a3
b/bb/b3
on the lines which lines youo want to copy
then
use command copy dataset name on command line to which you wanna copy

anything is possible if you use file aid with files
Back to top
View user's profile Send private message
senthilkumar selvaraju

New User


Joined: 30 May 2005
Posts: 16

PostPosted: Wed Jun 01, 2005 6:33 pm    Post subject:
Reply with quote

hi guys,

i am asking about cloumnwise search in file-aid. For example, if you want to search particular column in a table, just you try to put 'S' in left side of column names.
Back to top
View user's profile Send private message
sandra

New User


Joined: 06 Apr 2005
Posts: 27

PostPosted: Tue Jul 19, 2005 1:07 pm    Post subject: Re: Get the selected columns in a file by using file-aid too
Reply with quote

Using VPRINT function can I increase the width of report width .I need a VPRINT report output of a file of record lenghth 500.If so please specify the option for the same.
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: Mon Aug 27, 2007 6:09 pm    Post subject:
Reply with quote

Hello,

If you look in the Compuware Tools section of the forum, you will find several FileAid topics.
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am
No new posts Occurrence of various strings within ... TS70363 JCL & VSAM 1 Thu Apr 27, 2017 8:18 pm


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