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
 

 

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: 147
Location: Columbia, MO

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: 7306

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: 147
Location: Columbia, MO

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 Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am


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