IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Syncsort - Mulitiply problem in sort
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
PostPosted: Sat Jul 30, 2011 2:38 am
 Reply with quote
From the DFSORT APG description of TO=FS:

Quote:
For FS output, blank is used as the positive sign, - is used as the negative sign and leading zeros are suppressed.


If you want a + sign, you can use EDIT=(SII...IT),SIGNS=(+,-)

Quote:
DFSORT for sqlcode1 came up with 02300000


That doesn't make sense. DFSORT would have a leading blank, not a leading zero. For example, with:

Code:

...
//SORTIN DD *                                           
023     
123                                                 
//SORTOUT DD SYSOUT=*                                   
//SYSIN DD *                                             
  OPTION COPY                                           
  INREC BUILD=(1,3,ZD,MUL,+100000,TO=FS,LENGTH=9)       


SORTOUT has:

Code:

  2300000     
 12300000     


With

Code:

  INREC BUILD=(1,3,ZD,MUL,+100000,EDIT=(SIIIIIIIT),SIGNS=(+,-))


SORTOUT has:

Code:

 +2300000
+12300000
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 577
Location: USA
PostPosted: Sat Jul 30, 2011 3:06 am
 Reply with quote
Bill Woodger wrote:
Dick, I forgot it had moved :-)
With a 023 test case, multiplied by +100000 and TO=FS, DFSORT for sqlcode1 came up with 02300000. TS, using Syncsort, got +2300000.

huh? When?

We shouldn't be discussing this but the fact that OP got leading sign is/was because OP failed to provide us with correct test data. He would have leading sign originally in his file. That's why the job with SFF worked for him.

Thanks,
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
PostPosted: Sat Jul 30, 2011 4:04 am
 Reply with quote
Frank Yaeger wrote:
[...]
Quote:
DFSORT for sqlcode1 came up with 02300000


That doesn't make sense. DFSORT would have a leading blank, not a leading zero. [...]



Yes, sorry about that Frank, sorry sqlcode1. It did come up with a leading blank in sqlcode1's run. TS/OP claims a different result for the other product. End of story.

Thanks for the explanation as well.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 

Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us