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: 163
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: 163
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 Attachmate file transfer question John Poulakos All Other Mainframe Topics 2 Wed Mar 20, 2019 1:45 am
No new posts File data to symbolic parameter madprasy JCL & VSAM 5 Wed Mar 13, 2019 11:14 am
No new posts COBOL Table Question GAPX1 COBOL Programming 3 Thu Mar 07, 2019 9:48 pm
No new posts LRECL in syncsort frozenblood87 SYNCSORT 4 Tue Feb 19, 2019 6:50 am
This topic is locked: you cannot edit posts or make replies. PARAMETER 'F1' IS UNIDENTIFIED error ... Poha Eater DFSORT/ICETOOL 14 Fri Feb 01, 2019 2:39 pm

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