SYNCSORT output values gives me some junk number

teevijay · New User Joined: 20 Mar 2006 Posts: 22

One more clarification,
Do i really need to convert a BI field to FI to avoid a SUM FIELDS OVERFLOW ?

Thanks,
Vijay

Manuneedhi K · Posted: Tue Jul 08, 2008 7:26 pm Post subject:

AFAIK we used FI as the field was signed. This has nothing to do with the SUM FIELDS OVERFLOW problem.

teevijay · New User Joined: 20 Mar 2006 Posts: 22

Then it doesnt solve my problem.
Pls let me know, how to overcome a SUM FIELDS OVERFLOW for a BI field
Solution could be to convert it into a PD field and then do a SUM on it.
---> How do i do it ?

Any other solutions ?

Thanks.
Vijay

Craq Giegerich · Posted: Tue Jul 08, 2008 7:49 pm Post subject:

Manuneedhi K · Posted: Tue Jul 08, 2008 7:57 pm Post subject:

Try this in sum fields.

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

Manuneedhi K · Posted: Tue Jul 08, 2008 8:05 pm Post subject:

AFAIK you shouldn't have any problems of overflow now. Have you tested this with FI yet?

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

Vasukip · New User Joined: 17 Jun 2008 Posts: 49 Location: Chennai