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
 

 

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: 7223

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: 7223

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 syncsort: copy lines after the keyword shreya19 SYNCSORT 1 Fri Dec 02, 2016 9:47 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Overlaying one set of charater values... Kevin Lindsley SYNCSORT 7 Sat Nov 05, 2016 3:21 am


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