Use this command to round or truncate decimal numbers for SQL arithmetic.
Privilege Class
Any administrator can issue this command.
Syntax
.-Truncate--. >>-Set SQLMATHmode----+-----------+---------------------------->< +-Truncate--+ '-Round-----'
Parameters
Examples
Task
Set SQL arithmetic mode to TRUNCATE.
Related Commands
Table 277. Commands Related to SET SQLMATHMODE
Command | Description |
---|---|
QUERY SQLSESSION | Displays the current settings of the SQL formatting commands. |
SELECT | Allows customized queries of the TSM database. |
SET SQLDATETIMEFORMAT | Controls the formatting of date and time in the display of SQL queries. |
SET SQLDISPLAYMODE | Controls the column width in the display of SQL queries. |