IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Syncsort - SORT values within and columns !


IBM Mainframe Forums -> SYNCSORT
Post new topic   This topic is locked: you cannot edit posts or make replies.
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
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Jan 21, 2014 2:00 pm
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

Moderator Emeritus


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

PostPosted: Tue Jan 21, 2014 7:58 pm
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
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

Moderator Emeritus


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

PostPosted: Wed Jan 22, 2014 1:49 am
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Jan 22, 2014 6:44 pm
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. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
Search our Forums:

Back to Top