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
 
SyncSort Parameter Question

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

Active User


Joined: 05 Dec 2006
Posts: 153
Location: Seattle, WA

PostPosted: Sat Oct 06, 2012 2:21 am    Post subject: SyncSort Parameter Question
Reply with quote

I'm working with a SyncSort job, and came across the following line:

Code:
SORT FIELDS=(1,2,FI,A)


What is FI? The manual relates it to binary (BI), but doesn't go into any more detail.

The data in the field being sorted is (Zone/Digit format):
Code:
0123
0987


I would have used binary (BI), but maybe the FI is better?
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Sat Oct 06, 2012 3:29 am    Post subject: Reply to: SyncSort Parameter Question
Reply with quote

FI is signed. Left-most bit 1, indicates negative. BI is same thing, but unsigned, left-most bit is part of any value.

If you have signed-binary, and you want the negative values first in the sequence, you'd need FI. If you have unsigned binary, then you should use BI, else a mess can ensue.

So, can your field be negative? Is is from Cobol without TRUNC(BIN), so the maximum value is 9999? Then you'd not notice the difference from the output.

FI may be slower to process as it would have to differentiate between + and -, which BI doesn't. Not of much significance, I'd guess.

I'd also go for BI, unless it is a signed field. Unless from Cobol with TRUNC(BIN), then you'd have more checking-up to do :-)
Back to top
View user's profile Send private message
socker_dad

Active User


Joined: 05 Dec 2006
Posts: 153
Location: Seattle, WA

PostPosted: Mon Oct 29, 2012 7:15 pm    Post subject:
Reply with quote

The field cannot be negative (it's a state/region id number), so it looks like FI and BI are both acceptable choices; however, BI would make more logical sense.

Thanks for the insight!
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
No new posts SYNCSORT keep MIN/MAX record Cloink SYNCSORT 16 Mon Sep 17, 2018 3:00 pm
No new posts Cond parameter srini24 JCL & VSAM 10 Sun Sep 09, 2018 2:06 am
No new posts SOAP Message Handler Application Inte... John Poulakos CICS 1 Fri Aug 24, 2018 1:05 am
No new posts Dynamically updating the MQ monitorin... Anilkumarmq Java & MQSeries 0 Fri Jun 08, 2018 2:05 pm
No new posts To Understand EXECIO Read Parameter OPEN Ilavenil CLIST & REXX 2 Tue May 29, 2018 1:59 pm

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