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
 

 

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: 2285
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 Select numeric portion from CHAR data... balaji81_k DB2 1 Sat Aug 19, 2017 1:51 am
No new posts Validate if a Value from the file is ... balacsv2 COBOL Programming 8 Mon Jun 19, 2017 11:52 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am


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