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
 
String after '.' (period) is not copying in output

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 118

PostPosted: Wed Aug 23, 2017 9:35 pm    Post subject: String after '.' (period) is not copying in output
Reply with quote

Hi Team,
I am copying below input file data to output file by having filter '|' in between and sorting on first 4 bytes.
Problem is last field has alpha numeric date which has '.' in it . I am unable to copy the characters after period (i,e) '.' .

Input file:-
0111ABC888ABC.IUY

sort card used:-
Code:

SORT FIELDS =(1,4,ZD,A)
OUTREC BUILD=(1:1,4,
              5:C'|',
              6:5,3,
              9:C'|',
              10:8,3,
              13:11,7)


but output file is limited till ABC like below
Code:

0111 | ABC | 888 | ABC


Can any one help me on how we can copy the complete string .
Back to top
View user's profile Send private message

sergeyken

Active User


Joined: 29 Apr 2008
Posts: 379
Location: Maryland

PostPosted: Wed Aug 23, 2017 9:48 pm    Post subject:
Reply with quote

Add bounding characters around your suspicious field to verify what actually is printed, looking like blanks:

Code:
OUTREC BUILD=(1:1,4,
               5:C'|',
               6:5,3,
               9:C'|',
               10:8,3,
               13:C'>>>',11,7,C'<<<')
Back to top
View user's profile Send private message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 118

PostPosted: Wed Aug 23, 2017 9:58 pm    Post subject:
Reply with quote

Hi Sergeyken,

Its printed like >>> and then blanks .
Back to top
View user's profile Send private message
sergeyken

Active User


Joined: 29 Apr 2008
Posts: 379
Location: Maryland

PostPosted: Wed Aug 23, 2017 10:01 pm    Post subject:
Reply with quote

balaji81_k wrote:
Hi Sergeyken,

Its printed like >>> and then blanks .

Check in hex if they are REAL blanks? You can also temporary convert your output field to hex, for debugging.

If they are, verify carefully your data, and all offsets/lengths.

Definitely you have some stupid typo somewhere.
There are no such things as miracles.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2038
Location: NY,USA

PostPosted: Wed Aug 23, 2017 11:00 pm    Post subject:
Reply with quote

With your SORT CARD , you should get below output.
Code:
0111|ABC|888ABC.IUY

So you are not telling us everything accurate, please double check what you are doing.
Back to top
View user's profile Send private message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 118

PostPosted: Wed Aug 23, 2017 11:12 pm    Post subject:
Reply with quote

Hi Sergeyken,

Yes i did a small logic issue in my sort . Now i corrected it and it is working fine.

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

Active User


Joined: 29 Jun 2005
Posts: 118

PostPosted: Wed Aug 23, 2017 11:16 pm    Post subject:
Reply with quote

Rohit Umarjikar wrote:
With your SORT CARD , you should get below output.
Code:
0111|ABC|888ABC.IUY

So you are not telling us everything accurate, please double check what you are doing.


Hi Rohit,
Sorry , Yes you are correct about the output . I do have one more BI field in between where the length is not correctly specified in my sort(which i have modified now) . Apologize for the wrong output posted
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 -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. DFSORT output in CSV for data spans i... hiravibk DFSORT/ICETOOL 3 Tue Nov 13, 2018 7:55 pm
No new posts REFORMATTING WITH JFY CLOBBERING OUTP... speermb DFSORT/ICETOOL 12 Thu Nov 08, 2018 7:20 pm
No new posts UNSTRING a big string Apurva Ghogale COBOL Programming 16 Thu Sep 20, 2018 12:12 pm
No new posts Splitting one record in a file to 10 ... mf_123 DFSORT/ICETOOL 9 Tue Aug 21, 2018 8:51 pm
No new posts Formating of Amount field in CLIST be... Anil Kumar Prajapati CLIST & REXX 9 Fri Aug 03, 2018 6:34 pm

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