Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us