Tivoli Storage Manager for Windows Administrator's Reference

QUERY SQLSESSION (Display SQL Session Value)

Use this command to display the current values of the SQL session attribute.

Privilege Class

Any administrator can issue this command.

Syntax

>>-Query--SQLsession-------------------------------------------><
 

Parameters

None

Examples

Task

Display the current values of the SQL session attribute.

Command:
query sqlsession

Output:
+--------------------------------------------------------------------------------+
|                                                                                |
| Column      Date-Time     Arithmetic     Cursors                               |
|Display       Format          Mode        Allowed?                              |
| Format                                                                         |
|--------     ---------     ----------     --------                              |
| Narrow         ISO         Truncate        Yes                                 |
|                                                                                |
|                                                                                |
+--------------------------------------------------------------------------------+

Column Display Format
The format in which SQL data types are displayed. The default is NARROW, and it can be overidden by the SET SQLDISPLAYMODE command.

Date-Time Format
The format in which SQL date, time, and time stamp data are displayed. The default is ISO, and it can be overidden by the SET SQLDATETIMEFORMAT command.

Arithmetic Mode
The mode in which SQL arithmetic is carried out. The default is TRUNCATE, and it can be overidden by the SET SQLMATHMODE command.

Cursors Allowed?
The cursor is an object used for storing the output of a query for row by row processing by the application.

Related Commands

Table 201. Commands Related to QUERY SQLSESSION

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


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