Issue with aggregate function

General

Issue with aggregate function

Hi,

I am new to teradata and having problem with a simple aggregate function.

I am trying to a sum(sal) and instead of displaying a value it just displays ****

Below is the error I getting

Appreciate your help.

Thanks

Krishna

1 REPLY
Enthusiast

Re: Issue with aggregate function

Krishna,

I'm not sure what tool you are using.

When using BTEQ for instance, If a numeric output field in a report is defined with format '99.99'

and the answer is greater I.E.: 100.00 , It will be desplayed as ****

The format would need to be '999.99'

Rglass