Tivoli Storage Manager for Sun Solaris Administrator's Reference

SET SQLMATHMODE (Set the Mode for SQL Arithmetic)

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

Truncate
Specifies that decimal numbers are truncated according to DB2 SQL formulas. TRUNCATE is the default.

Round
Specifies that decimal numbers are rounded according to DB2 SQL formulas.

Examples

Task

Set SQL arithmetic mode to TRUNCATE.

Command:
set sqlmathmode 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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]