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
 

 

How to See few columns in a dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
ganna_f16

New User


Joined: 07 Mar 2005
Posts: 17
Location: India

PostPosted: Wed Apr 18, 2007 4:40 pm    Post subject: How to See few columns in a dataset
Reply with quote

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).
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Apr 18, 2007 5:14 pm    Post subject:
Reply with quote

You cannot view few columns of a flat file. Use DFSORT for reformatting or extracting the required columns into another file. Sample JCL is as -

Code:
//sortin dd dsn=your.ipfile,disp=shr
//sortout dd dsn=your.opfile,disp=.......
//sysin dd *
   option copy
   outrec fields=(1,20,             * column 1
                        35,21,           * column 2
                        100,25)         * column 3
/*


The OP file contains only the required fileds
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Thu Apr 19, 2007 5:44 am    Post subject:
Reply with quote

If you have FileAid it's fairly simple.

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.
Back to top
View user's profile Send private message
IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Thu Apr 19, 2007 7:07 pm    Post subject: Re: How to See few columns in a dataset
Reply with quote

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.               
                                                                           
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 964
Location: Richmond, Virginia

PostPosted: Thu Apr 19, 2007 9:46 pm    Post subject:
Reply with quote

The above works, but is tedious, and is restricted to datasets small enough to edit/view.

If it switches you to browse mode, forget it.
Back to top
View user's profile Send private message
Shrimathi Krishnan

New User


Joined: 19 Apr 2007
Posts: 39
Location: Chennai

PostPosted: Fri Apr 20, 2007 11:30 am    Post subject:
Reply with quote

Hi all

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.

Once done press enter and F3 to get the data..
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts Browse dataset cvnlynn CLIST & REXX 4 Tue Jul 18, 2017 3:52 am
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm


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