View previous topic :: View next topic
|
Author |
Message |
teevijay
New User
Joined: 20 Mar 2006 Posts: 22
|
|
|
|
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 |
|
|
Manuneedhi K
Active User
Joined: 07 May 2008 Posts: 115 Location: Chennai
|
|
|
|
AFAIK you shouldn't have any problems of overflow now. Have you tested this with FI yet? |
|
Back to top |
|
|
teevijay
New User
Joined: 20 Mar 2006 Posts: 22
|
|
|
|
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 |
|
|
Vasukip Currently Banned New User
Joined: 17 Jun 2008 Posts: 48 Location: Chennai
|
|
|
|
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 |
|
|
|