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
 
Numeric conversion in Syncsort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
bodatrinadh

Active User


Joined: 05 Jan 2007
Posts: 101
Location: chennai (India)

PostPosted: Thu Dec 09, 2010 6:38 pm    Post subject: Numeric conversion in Syncsort
Reply with quote

I have a delimited input file.

Code:

GTURO|BPH|0002400000312|EQUALIZE||CUR|0.250|XPO
GTURO|BPH|0002400000313|EQUALIZE||CUR|0.250|XPO
GTURO|BPH|0002400000310|EQUALIZE||CUR|0.250|XPO
GTURO|BPH|0002400000311|EQUALIZE||CUR|0.250|XPO


and my desired output is

Code:

GTURO BPH0002400000312 EQUALIZE CUR 00025{XPO
GTURO BPH0002400000313 EQUALIZE CUR 00025{XPO
GTURO BPH0002400000310 EQUALIZE CUR 00025{XPO
GTURO BPH0002400000311 EQUALIZE CUR 00025{XPO


My current sort looks like this:

Code:

SORT FIELDS=COPY,SKIPREC=1
OUTREC PARSE=(%01=(ENDBEFR=C'|',FIXLEN=10),
%02=(ENDBEFR=C'|',FIXLEN=3),
%03=(ENDBEFR=C'|',FIXLEN=13),
%04=(ENDBEFR=C'|',FIXLEN=8),
%05=(ENDBEFR=C'|',FIXLEN=3),
%06=(ENDBEFR=C'|',FIXLEN=3),
%07=(ENDBEFR=C'|',FIXLEN=6),
%08=(ENDBEFR=C'|',FIXLEN=3)),
BUILD=(01:%01,JFY=(SHIFT=LEFT),
11:%02,JFY=(SHIFT=LEFT),
14:%03,JFY=(SHIFT=LEFT),
27:%05,JFY=(SHIFT=LEFT),
37:%04,JFY=(SHIFT=LEFT),
47:%06,JFY=(SHIFT=LEFT),
57:%07,JFY=(SHIFT=LEFT),
63:%08,JFY=(SHIFT=LEFT),66:10X),CONVERT



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

Anuj Dhawan

Senior Member


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

PostPosted: Thu Dec 09, 2010 8:12 pm    Post subject:
Reply with quote

You already have this similar topic: http://ibmmainframes.com/viewtopic.php?t=52491&highlight=

Which one do you want to keep?
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2352
Location: @my desk

PostPosted: Thu Dec 09, 2010 8:22 pm    Post subject:
Reply with quote

Anuj,

I think the TS is only interested in making multiple posts and not in responding to any of the questions asked.

bodatrinadh

By doing multiposting, you are just wasting your own time.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Reformatting and adding additional fi... Badbeef SYNCSORT 6 Thu Apr 05, 2018 4:45 pm
No new posts Sort numeric fields with trailing spaces sancraig16 SYNCSORT 7 Tue Apr 03, 2018 1:21 am
No new posts Conversion of DLI update Jobs as BMP ... Gopinath Shanmugam IMS DB/DC 3 Wed Dec 20, 2017 12:02 pm
No new posts Moving a COMP-3 Variable to a Numeric... ajayachander COBOL Programming 2 Thu Dec 14, 2017 5:46 pm
No new posts Conversion of UTF-8 to EBCDIC muralikrishnan_new COBOL Programming 1 Tue Nov 21, 2017 5:33 pm

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