Using Justify statement in SYNCSORT

mushreyas · New User Joined: 18 Jul 2008 Posts: 59 Location: Bangalore

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.

Arun Raj · Posted: Tue Aug 16, 2011 9:10 pm

mushreyas,

Show a few sample input records and the expected output out of it along with the input/output file attributes

mushreyas · New User Joined: 18 Jul 2008 Posts: 59 Location: Bangalore

Hi,

Sample Input

mushreyas · New User Joined: 18 Jul 2008 Posts: 59 Location: Bangalore

Input file is of 5 bytes Fixed format and same goes with output file.

dick scherrer · Posted: Wed Aug 17, 2011 7:01 am

Hello,

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

Look at the UFF data format maybe.

mushreyas · New User Joined: 18 Jul 2008 Posts: 59 Location: Bangalore

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

dick scherrer · Posted: Wed Aug 17, 2011 10:38 pm

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. . .

mushreyas · New User Joined: 18 Jul 2008 Posts: 59 Location: Bangalore

Thanks Dick. It worked...

dick scherrer · Posted: Fri Aug 19, 2011 1:48 am

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

d