![]() |
![]() |
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 251. Commands Related to SET SQLMATHMODE
Command | Description |
---|---|
QUERY SQLSESSION | Displays the current settings of the SQL formatting commands. |
SELECT | Allows customized queries of the Tivoli Storage Manager 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. |