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
To view only selected columns
-
- Posts: 278
- Joined: Thu May 15, 2008 9:45 pm
- Skillset: MVS
MQ
ISPF - Referer: sister site
Re: To view only selected columns
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.
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.
-
- Posts: 2
- Joined: Mon Jun 09, 2008 10:28 am
- Skillset: Cobol, JCl,VSAm and DB2.
- Referer: Friends
Re: To view only selected columns
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.
=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.
-
- 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
You can run macros like
which will change the data to spaces for more information check "ISPF Edit Macros"
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"
-
- 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
If you have some file viewer and you know exact column number you want to see can use DISP ONLYcommand
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: To view only selected columns
Hello,
What is "some file viewer"?
DISP ONLY is not a standard view/edit command.
What is "some file viewer"?
DISP ONLY is not a standard view/edit command.
Hope this helps,
d.sch.
d.sch.
-
- 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
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
Regards
Nic
-
- 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
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".
For example for column number 2 and 8 , " disp 2 8 only".
-
- 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
I have found the ISPF solution - on the edit entry panel is a field
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.
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
Regards
Nic
-
- Similar Topics
- Replies
- Views
- Last post
-
- 3
- 1577
-
by sergeyken
View the latest post
Thu May 13, 2021 1:07 am
-
- 6
- 2697
-
by Pedro
View the latest post
Sun Nov 14, 2021 11:28 am
-
- 5
- 1778
-
by willy jensen
View the latest post
Fri Dec 03, 2021 8:16 pm
-
- 3
- 3822
-
by sergeyken
View the latest post
Thu Mar 25, 2021 7:12 pm
-
-
Parsing more than 1000 columns in a sort card Reply with quo
by ssuthagar » Tue Sep 22, 2020 3:02 am » in Syncsort/Synctool - 1
- 3440
-
by sergeyken
View the latest post
Tue Sep 22, 2020 9:06 pm
-