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

senthilkumar selvaraju · New User Joined: 30 May 2005 Posts: 16

Is it possible to get the selected columns in a file by using file-aid tool

jkbytes · Posted: Tue May 31, 2005 5:38 pm

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

kanak · Moderator Joined: 12 Mar 2005 Posts: 252 Location: India

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....

eashwar · New User Joined: 21 May 2005 Posts: 26 Location: Bangalore

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

senthilkumar selvaraju · New User Joined: 30 May 2005 Posts: 16

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.

sandra · New User Joined: 06 Apr 2005 Posts: 27

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.

dick scherrer · Posted: Mon Aug 27, 2007 6:09 pm

Hello,

If you look in the Compuware Tools section of the forum, you will find several FileAid topics.