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
 
Syncsort - SORT values within and columns !

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Mon Jan 20, 2014 1:26 pm    Post subject: Syncsort - SORT values within and columns !
Reply with quote

Hi,

I have the below input file with some data values and need to have same type appearing in one column and so on.....

Input:- LRECL=80,RECFM=FB
Code:

MARG1 DATA1 MANS3 SELI5
MANS3 SELI5 MARG1
SELI5 MARG1 DATA1
FINP6 MANS3 HOFG4 MARG1 KIPL9 OLIV2
MANS3 SELI5


The expected output should be in the below given format:
Code:

                        MANS3             SELI5
                        MANS3 MARG1       SELI5
      FINP6 HOFG4 KIPL9 MANS3 MARG1 OLIV2
DATA1                         MARG1       SELI5
DATA1                   MANS3 MARG1       SELI5


Please help.

Thanks.
Back to top
View user's profile Send private message

sureshpathi10

Active User


Joined: 03 May 2010
Posts: 154
Location: Kuala Lumpur

PostPosted: Mon Jan 20, 2014 4:02 pm    Post subject:
Reply with quote

Are all these values fixed or will it vary time to time?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Tue Jan 21, 2014 2:00 pm    Post subject: Reply to: Syncsort - SORT values within and columns !
Reply with quote

Ramsri,

You need to provide a full and complete explanation of your data. Also, what is the LRECL and RECFM of your output?
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: Tue Jan 21, 2014 7:58 pm    Post subject:
Reply with quote

Hello,

Once again, you have provided far too little and expect people here to write your code for you icon_sad.gif

If you want help, you need to clearly post the "rules" for getting from the input to the output. What you have posted is some alphabet-soup that has little or no meaning to most of us. You might understand what you are working with but we cannot.

Unless you provide proper info, this topic will be locked/deleted.

Hopefully, no one else will waste time on this . . .
Back to top
View user's profile Send private message
Paresh123

New User


Joined: 02 Jan 2014
Posts: 4
Location: USA

PostPosted: Wed Jan 22, 2014 1:43 am    Post subject:
Reply with quote

Perhaps this would be better accomplished in Easytrieve or COBOL?
In Easytrieve, use the case statement on each input field and assign to the output field accordingly.
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: Wed Jan 22, 2014 1:49 am    Post subject:
Reply with quote

Hello,

I suspect the "language" doesn't matter so much if the task cannot be described/explained . . .
Back to top
View user's profile Send private message
ramsri

Active User


Joined: 18 Oct 2008
Posts: 380
Location: India

PostPosted: Wed Jan 22, 2014 4:51 pm    Post subject: Reply to: Syncsort - SORT values within and columns !
Reply with quote

sorry folks.....its not real situation icon_eek.gif but an idea that I tried to work out and ended up posting here icon_redface.gif to seek experts advice.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Wed Jan 22, 2014 6:44 pm    Post subject: Reply to: Syncsort - SORT values within and columns !
Reply with quote

Even for ideas, we need to know about the data and about the rules.

If the data is known, it can be done with PARSE. If unknown, but limited, perhaps generate the PARSE. If unknown and unlimited can't reasonably be done...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Can EDCICONV convert EBCDIC to ASCII... natt.sut IBM Tools 3 Fri Nov 17, 2017 8:46 pm
No new posts JOINKEYS Paired and Unpaired Sort on ... MFwhiz DFSORT/ICETOOL 7 Tue Nov 07, 2017 2:46 am
No new posts Copy selected columns from 2 input fi... Poha Eater DFSORT/ICETOOL 3 Thu Nov 02, 2017 3:43 pm
No new posts Extend the decimal values in DIVISION Balaryan DFSORT/ICETOOL 3 Thu Oct 05, 2017 4:05 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm

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