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

SYNCSORT output values gives me some junk number


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
teevijay

New User


Joined: 20 Mar 2006
Posts: 22

PostPosted: Tue Jul 08, 2008 7:57 pm
Reply with quote

Craq,
you mean to say that instead of using BI, i should use FI ?
SUM FIELDS = (139,8,FI) would do to eliminate the overflow ?

Thanks,Vijay
Back to top
View user's profile Send private message
Manuneedhi K

Active User


Joined: 07 May 2008
Posts: 115
Location: Chennai

PostPosted: Tue Jul 08, 2008 8:05 pm
Reply with quote

AFAIK you shouldn't have any problems of overflow now. Have you tested this with FI yet?
Back to top
View user's profile Send private message
teevijay

New User


Joined: 20 Mar 2006
Posts: 22

PostPosted: Tue Jul 08, 2008 8:19 pm
Reply with quote

Thanks Craq and Manu.
I have tested for few sample records and now running it for the entire file of over 20 M records.
Wll keep you posted about the results.

Thanks again.
Vijay
Back to top
View user's profile Send private message
Vasukip
Currently Banned

New User


Joined: 17 Jun 2008
Posts: 48
Location: Chennai

PostPosted: Wed Jul 09, 2008 3:42 pm
Reply with quote

teevijay wrote:
Thanks Manu,

i just gave this as a test

SORT FIELDS=COPY,STOPAFT=10
OUTREC BUILD=(139,8,FI,EDIT=(STTTTTTTTTTTTTTTTTT),SIGNS=(,-))
SUM FIELDS=(139,8)

just as a clarification, is the above thing correct !?


Hi,
here in SUM FIELDS statement you gotta give format Type i.e BI or ZD
SUM FIELDS=(139,8,BI) or SUM FIELDS=(139,8,ZD)
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 INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top