Hi,
I am having a sequential file of LRECL=130. There are different columns in the files. How can I view only few columns. For Example Column1 (1-20), column2 (35-56) and column3 (100-125).
View the file "format"ed, that is, specify a copybook in the space provided.
After you bring up the file, enter "s n" (show names) on the cmd line. Note the numbers (shown to the left of the field names) of the fields you want to view, then enter (for example):
display only 1 2 9-13 72 108
The 9-13 references a range of fields beginning at field 9 and ending at 13.
It all depends, you can view the columns in a flat file if you have the Format option in your release.
eg do you have this in Veiw or Edit main screens?
Code:
EDIT/VIEW parameters:
Initial Macro ===> Confirm Cancel/Move/Replace ===> N (Y, N)
Profile Name ===> Action Bar in Edit/View ===> Y (Y, N)
Format Name ===> Highlight coloring in Edit/View ===> Y (Y, N)
Preserve VB record length => N Mixed Mode (NLS DBCS char. set) ===> N (Y, N)
the Format name has to be created in option 3.11 (if you have it)
Code:
Utility Selection Panel
Option ===>
1 Library Compress or print data set. Print index listing. Print,
rename, delete, browse, edit or view members
2 Data Set Allocate, rename, delete, catalog, uncatalog, or display
information of an entire data set
3 Move/Copy Move, or copy members or data sets
4 Dslist Print or display (to process) list of data set names.
Print or display VTOC information
5 Reset Reset statistics for members of ISPF library
6 Hardcopy Initiate hardcopy output
7 Transfer Download ISPF Client/Server or Transfer data set
8 Outlist Display, delete, or print held job output
9 Commands Create/change an application command table
11 Format Format definition for formatted data Edit/Browse
12 SuperC Compare data sets (Standard Dialog)
13 SuperCE Compare data sets Extended (Extended Dialog)
14 Search-For Search data sets for strings of data (Standard Dialog)
15 Search-ForE Search data sets for strings of data Extended (Extended Dialog)
use the help to guide you through.
Code:
Format Specifications
Option ===>
A Add a new format
C Copy formats
D Delete a format
U Update format
L or BLANK Display format list
Format Name . . . XX
For COPY operations, specify the following:
From Format . . . (Blank for format list, * for all formats)
From Table . . . (Default is "ISRFORM" )
Note: The Format Utility is provided for support of the IBM 5550 terminal
using the Double-byte Character Set (DBCS).
Code:
Command ===>
Field Start Field Field Field Start Field Field
Number Column Length Type Number Column Length Type
1 00001 10 M 2 00020 05 M
3 00000 00 _ 4 00000 00 _
5 00000 00 _ 6 00000 00 _
7 00000 00 _ 8 00000 00 _
9 00000 00 _ 10 00000 00 _
11 00000 00 _ 12 00000 00 _
13 00000 00 _ 14 00000 00 _
15 00000 00 _ 16 00000 00 _
17 00000 00 _ 18 00000 00 _
19 00000 00 _ 20 00000 00 _
Field Number: Identifies the field position on the screen.
Start Column: From 1 to 32760; Specifies column position in the record.
field Length: From 1 to 71; Fields must not overlap.
Field Type : E - single-byte, D - double-byte, M - mixed data
Enter the END command to exit and save the format.
Enter the CANCEL command to exit without saving the format.
This can done in File aid in VFMT itself. OPen the dataset which u want to view and type hold in the command line. You will get the hide and hold pop up. In that type h besides the fields which u want to hold for view and x for hiding the field from diplay.