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 select two or more columns in a PS file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
View previous topic :: :: View next topic  
Author Message
chengaiprabha

New User


Joined: 27 Aug 2008
Posts: 3
Location: India

PostPosted: Sat Sep 20, 2008 3:37 pm    Post subject: How to select two or more columns in a PS file
Reply with quote

How we can select two or more columns in a PS file
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Sat Sep 20, 2008 3:53 pm    Post subject:
Reply with quote

Can you please explain what you want to do in detail and maybe then someone will be able to help you.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Sep 20, 2008 8:59 pm    Post subject:
Reply with quote

Hello and welcome to the forums,

If you post some sample input and the output you want when that sample input is processed, someone will be able to help.
Back to top
View user's profile Send private message
chengaiprabha

New User


Joined: 27 Aug 2008
Posts: 3
Location: India

PostPosted: Fri Oct 10, 2008 4:18 am    Post subject:
Reply with quote

Hi,

If I have 20 columns and 1000 rows of each(field length) 10 characters length, how we can extract clolumns 1,2,3,6,8,13,16,17,19 and 20 by ordinary edit commands in PS file. Thanks.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Oct 10, 2008 6:05 am    Post subject:
Reply with quote

If you have a COPYBOOK Layout for this file this can be done using DISP ONLY ..

By the way, when you say "extract" here
Quote:
how we can extract clolumns
what exactly does that mean ? Do you want the "extracted" columns in other file or the source file itself be edited..or you want to have a temporary mask on these columns ? Please clarify.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Oct 10, 2008 6:30 am    Post subject:
Reply with quote

Hello,

From part of my earlier reply:
Quote:
post some sample input and the output
You need to post some sample input data and the output you want from that input.

You do not need to post full width or length of the data. Show 5 "columns" and 4 "rows". Show your output as though only columns 2 and 4 were to be extracted.

It is likely that this will be better done using your sort product. Please explain any rules or restrictions as to which tool(s) may be used (or are prohibited).
Back to top
View user's profile Send private message
chengaiprabha

New User


Joined: 27 Aug 2008
Posts: 3
Location: India

PostPosted: Fri Oct 10, 2008 11:16 pm    Post subject:
Reply with quote

Thanks.. Actually 'extract' here I mean is editing within the PS file.
Iam not using any tool here, Just manual edit operations. Some where I read that '(' chracter is used for selection of columns but I want to know
how this could be done. Could you please advise .. Thanks.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Oct 10, 2008 11:23 pm    Post subject:
Reply with quote

Hello,

Which part of "post some sample input and output" was not clear?

As i mentioned before:
Quote:
You do not need to post full width or length of the data. Show 5 "columns" and 4 "rows". Show your output as though only columns 2 and 4 were to be extracted.


Replies other than your sample data will be deleted until you have posted the requested inifo.
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 -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


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