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: 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 File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts Return a Non Numeric value from REXX Learncoholic CLIST & REXX 3 Fri Sep 01, 2017 8:33 pm
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am

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