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
 

 

Using Justify statement in SYNCSORT

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

New User


Joined: 18 Jul 2008
Posts: 59
Location: Bangalore

PostPosted: Tue Aug 16, 2011 8:58 pm    Post subject: Using Justify statement in SYNCSORT
Reply with quote

Hi,

I have to sort first 5 bytes of character data of an input record which is left justified. But before sorting i need to right justify the data and then convert character data (which is always numeric) into binary format.

I have searched for JUSTIFY statement in SYNCSORT manual which i have and couldn't find anything. Hence turning over to you guys for help.
Back to top
View user's profile Send private message

Arun Raj

Moderator


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

PostPosted: Tue Aug 16, 2011 9:10 pm    Post subject:
Reply with quote

mushreyas,

Show a few sample input records and the expected output out of it along with the input/output file attributes
Back to top
View user's profile Send private message
mushreyas

New User


Joined: 18 Jul 2008
Posts: 59
Location: Bangalore

PostPosted: Wed Aug 17, 2011 6:54 am    Post subject: Reply to: Using Justify statement in SYNCSORT
Reply with quote

Hi,

Sample Input
Code:

5     
4     
9     
1     
6     

Output should be as below
Code:

00005
00004
00009
00001
00006


And i should convert this to Binary which i will be able to once i do the justification.
Back to top
View user's profile Send private message
mushreyas

New User


Joined: 18 Jul 2008
Posts: 59
Location: Bangalore

PostPosted: Wed Aug 17, 2011 6:55 am    Post subject: Reply to: Using Justify statement in SYNCSORT
Reply with quote

Input file is of 5 bytes Fixed format and same goes with output file.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 17, 2011 7:01 am    Post subject:
Reply with quote

Hello,

You should be able to convert these values to binary without the justify (in the BUILD).

Look at the UFF data format maybe.
Back to top
View user's profile Send private message
mushreyas

New User


Joined: 18 Jul 2008
Posts: 59
Location: Bangalore

PostPosted: Wed Aug 17, 2011 9:58 pm    Post subject: Reply to: Using Justify statement in SYNCSORT
Reply with quote

Hi Dick,

Is the UFF format available with SYNCSORT? If so can it converts the data after justification to Binary.

Should it be coded like below
Code:

OUTREC FIELDS=(1,5,UFF,M11)
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 17, 2011 10:38 pm    Post subject:
Reply with quote

Hello,

What happens when you try it?

'Tis free to try and should cause no problems. . .

A local test will almost always be quicker than the forum. . .

Quote:
Is the UFF format available with SYNCSORT?
Yes, UFF is available with Syncsort.
Back to top
View user's profile Send private message
mushreyas

New User


Joined: 18 Jul 2008
Posts: 59
Location: Bangalore

PostPosted: Thu Aug 18, 2011 9:23 pm    Post subject: Reply to: Using Justify statement in SYNCSORT
Reply with quote

Thanks Dick. It worked...icon_smile.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 19, 2011 1:48 am    Post subject: Reply to: Using Justify statement in SYNCSORT
Reply with quote

Good to hear it is working - thank you for letting us know icon_smile.gif

d
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 Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am


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