To view only selected columns

Yash19
Posts: 2
Joined: Mon Jun 09, 2008 10:28 am
Skillset: Cobol, JCl,VSAm and DB2.
Referer: Friends

To view only selected columns

Postby Yash19 » Wed Oct 08, 2008 5:23 pm

Hi,
Is there any command to view only specific columns.

eg. If want to see columns from 2 to 10 only then which command should use.

Regards,
Yash

Bill Dennis
Posts: 278
Joined: Thu May 15, 2008 9:45 pm
Skillset: MVS
MQ
ISPF
Referer: sister site

Re: To view only selected columns

Postby Bill Dennis » Wed Oct 08, 2008 6:23 pm

View what type of file with which viewer?
Regards,

Bill Dennis

Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.

Yash19
Posts: 2
Joined: Mon Jun 09, 2008 10:28 am
Skillset: Cobol, JCl,VSAm and DB2.
Referer: Friends

Re: To view only selected columns

Postby Yash19 » Fri Oct 10, 2008 10:29 am

Suppose the file is in the format, like as

=COLS> ----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
****** ***************************** Top of Data ******************************
000001 ####KADAM##############################################
000002 ####RAKES###############################################
000003 ####SUSHI###############################################
000004 ####ANANT###############################################


Now I want to view the text starting from column 5 upto column 9 only for all rows, and want to delete other part.
Please guide me which command should I use.

rajithr007
Posts: 13
Joined: Thu Sep 11, 2008 11:31 am
Skillset: Rexx,Clist,ISPF Panel, Skel, Messages, TSO Command, JCL, Cobol, DB2,CICS, VSAM, Fileaid
Referer: friends

Re: To view only selected columns

Postby rajithr007 » Tue Oct 28, 2008 9:16 pm

You can run macros like

Code: Select all

C ALL P'=' ' ' 1 4;C ALL P'=' ' ' 10 80

which will change the data to spaces for more information check "ISPF Edit Macros"

ritikasingh
Posts: 39
Joined: Wed Sep 01, 2010 9:12 pm
Skillset: Operating Systems: MVS
Environment: Mainframe, Windows
Databases: VSAM, DB2 Tables
Programming Languages: COBOL, JCL,TSO/ISPF, CICS, DB2 (SQL),
Software Tools: File-AID, Endeavor, SORT, ICETOOL, SNDM, HP Quality Center,
OPC, DRMS,IDCAMS, SMARTIS, VISIO, Vision plus, HP(Service Manager),TSO,ISPF
Referer: google

Re: To view only selected columns

Postby ritikasingh » Fri Oct 22, 2010 12:29 am

If you have some file viewer and you know exact column number you want to see can use DISP ONLYcommand

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

Re: To view only selected columns

Postby dick scherrer » Fri Oct 22, 2010 2:41 am

Hello,

What is "some file viewer"?

DISP ONLY is not a standard view/edit command.
Hope this helps,
d.sch.

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

Re: To view only selected columns

Postby NicC » Fri Oct 22, 2010 10:14 am

I have worked at a place that had an ISPF facility which allowed one to specify which columns you wanted displayed. I looked at my current system and cannot find any reference to this so it is obviously a more recent version of ISPF. I cannot remember the command either so that is not much good but be aware that in ISPF there MAY be a facility for what you want. Just dig around, look at the edit entry panel (where you speciy the file to be printed).
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

ritikasingh
Posts: 39
Joined: Wed Sep 01, 2010 9:12 pm
Skillset: Operating Systems: MVS
Environment: Mainframe, Windows
Databases: VSAM, DB2 Tables
Programming Languages: COBOL, JCL,TSO/ISPF, CICS, DB2 (SQL),
Software Tools: File-AID, Endeavor, SORT, ICETOOL, SNDM, HP Quality Center,
OPC, DRMS,IDCAMS, SMARTIS, VISIO, Vision plus, HP(Service Manager),TSO,ISPF
Referer: google

Re: To view only selected columns

Postby ritikasingh » Fri Oct 22, 2010 7:57 pm

I worked on FILEAID. If i wanted to see any column, I opened the file and write the column number.
For example for column number 2 and 8 , " disp 2 8 only".

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

Re: To view only selected columns

Postby NicC » Sat Oct 23, 2010 12:54 am

I have found the ISPF solution - on the edit entry panel is a field

Code: Select all

Format Name

Here you enter the name of a format which is set up in option 3.11 - ignore the bit about it being for 5550 screens or dbcs: it works just dandy with 3270 type screens.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic


  • Similar Topics
    Replies
    Views
    Last post