Tivoli Storage Manager for HP-UX Administrator's Reference

SET SQLDISPLAYMODE (Set the Display of SQL Data Types)

Use this command to control how SQL data types are displayed.

Privilege Class

Any administrator can issue this command.

Syntax

                         .-Narrow--.
>>-Set SQLDISPlaymode----+---------+---------------------------><
                         +-Narrow--+
                         '-Wide----'
 

Parameters

Narrow
Specifies that the column display width is set to 18. Any wider string is forced onto multiple lines at the client. NARROW is the default.

Wide
Specifies that the column display width is set to 250.

Examples

Task

Set the SQL data type display to wide column.

Command:
set sqldisplaymode wide

Related Commands

Table 265. Commands Related to SET SQLDISPLAYMODE

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 SQLMATHMODE Controls how decimal numbers are displayed in SQL queries.


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