Specifies if the number of decimal places used in the display of numeric data is fixed.
SET FIXED ON | OFF |
Parameters
- ON
- Uses the SET DECIMALS setting to determine the number of decimal places displayed in results. The default number of decimal places is 2.
- OFF
- (Default) Allows the number of decimal places displayed in results to depend on the specific constants, variables, and operators used in a numeric expression. The contents of fields are displayed with the declared number of decimal places.
Remarks
SET FIXED is scoped to the current data session.