IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

String after '.' (period) is not copying in output


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 141

PostPosted: Wed Aug 23, 2017 9:35 pm
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 Member


Joined: 29 Apr 2008
Posts: 879
Location: Maryland

PostPosted: Wed Aug 23, 2017 9:48 pm
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: 141

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

Hi Sergeyken,

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

Active Member


Joined: 29 Apr 2008
Posts: 879
Location: Maryland

PostPosted: Wed Aug 23, 2017 10:01 pm
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

Global Moderator


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

PostPosted: Wed Aug 23, 2017 11:00 pm
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: 141

PostPosted: Wed Aug 23, 2017 11:12 pm
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: 141

PostPosted: Wed Aug 23, 2017 11:16 pm
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 All times are GMT + 6 Hours
Forum Index -> SYNCSORT
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Need to split single line into two li... DFSORT/ICETOOL 7
No new posts Copying data from prev record using SORT SYNCSORT 19
No new posts Altering output file attributes All Other Mainframe Topics 5
No new posts DB2 - row_number function - Need 1st ... DB2 5
No new posts Copying Db2 BSDS and logs to another ... JCL & VSAM 11

Back to Top