SHOW SESSION Command

SHOW SESSION or SESSION displays attributes of the current Neoview Script session. You can also use the ENV command to perform the same function.

Syntax

[SHOW] SESSION

Considerations

•In the Neoview Script interface, you must enter the command on one line. The command does not require an SQL terminator.

•SHOW SESSION or SESSION displays these attributes:

COLSEP

Current column separator, which is used to control how query results are

 

presented. For more information, see “SET COLSEP Command” (page 101).

DATASOURCE

Name of the data source that you entered when logging in to the database platform.

 

For more information, see “Logging In to the Database Platform” (page 45).

HISTOPT

Current history options, which controls how the commands are added to the

 

history buffer. For more information, see “SET HISTOPT Command” (page 102).

IDLETIMEOUT

Current idle timeout value, which determines when the session expires after a

 

period of inactivity. By default, the idle timeout is 30 minutes. For more

 

information, see “Setting and Showing the Idle Timeout Value for the Session”

 

(page 53) and “SET IDLETIMEOUT Command” (page 103).

LIST COUNT

Current list count, which is the maximum number of rows that can be returned

 

by SELECT statements. By default, the list count is all rows. For more information,

 

see “SET LIST_COUNT Command” (page 106).

LOG

Current log file and the directory containing the log file. By default, logging during

 

a session is turned off. For more information, see “Logging Output” (page 63)

 

and “LOG Command” (page 91) or “SPOOL Command” (page 130).

LOOK AND FEEL

Current look and feel of the Neoview Script interface. This property affects the

 

formatting of status messages. For more information, see “Setting the Look and

 

Feel of the Neoview Script Interface” (page 35).

MARKUP

Current markup option selected for the session. The default option is RAW. For

 

more information, see “SET MARKUP Command” (page 104).

MODE

Current operating mode of the session. The default mode is SQL. For more

 

information, see “MODE Command” (page 92).

PROMPT

Current prompt for the session. In SQL mode, the default is SQL>. In CS mode,

 

the default is CS#. For more information, see “Customizing the Standard Prompt”

 

(page 53) and “SET PROMPT Command” (page 109).

SCHEMA

Current schema. The default is USR. For more information, see “Setting and

 

Showing the Current Schema” (page 55).

SERVER

Host name and port number that you entered when logging in to the database

 

platform. For more information, see “Logging In to the Database Platform”

 

(page 45).

SQLTERMINATOR

Current SQL statement terminator. The default is a semicolon (;). For more

 

information, see “Setting and Showing the SQL Terminator” (page 54) and “SHOW

 

SQLTERMINATOR Command” (page 124).

TIME

Current setting (on or off) of the local time as part of the prompt. By default, the

 

local time is off. For more information, see “Customizing the Standard Prompt”

 

(page 53) and “SET TIME Command” (page 112).

122 Neoview Script Interface Commands

Page 121 Page 123
Page 122
Image 122
HP NEOVIEW 544530-001 manual Show Session Command
Page 121 Page 123

NEOVIEW 544530-001 specifications

The HP Neoview 544530-001 is a sophisticated data warehousing solution that was designed to address the complex demands of modern businesses. Known for its robust architecture, it enables organizations to efficiently manage, store, and process vast amounts of data. This appliance offers a cohesive combination of hardware and software, configured to deliver high performance and reliability for business intelligence applications.

One of the standout features of the HP Neoview 544530-001 is its ability to support large-scale data analytics. The system utilizes a massively parallel processing architecture, which allows it to handle multiple data queries simultaneously, thereby enhancing the overall performance and response time. This characteristic is vital for businesses that rely on real-time data analysis to make informed decisions.

Another significant technology embedded in the Neoview 544530-001 is its advanced data storage capabilities. With generous storage capacity, it can accommodate extensive datasets, ensuring that organizations have the flexibility to grow their data without compromising system performance. The appliance also integrates advanced compression techniques, which optimize storage efficiency, reducing the physical space required and associated costs.

The HP Neoview is engineered with various data management features, including data quality tools that help ensure the integrity and accuracy of information. These tools can cleanse and normalize data, making it more reliable for analysis. Moreover, the system supports a wide array of data formats, facilitating easy integration with existing databases and applications.

Security is also a critical consideration for the HP Neoview 544530-001. The appliance incorporates robust security measures to protect sensitive data from unauthorized access. This includes encrypted connections and user authentication protocols, which are essential for compliance with industry standards.

In terms of scalability, the Neoview 544530-001 allows businesses to expand their data environment as their needs evolve. The system's modular architecture means that organizations can easily add hardware components, ensuring they can keep pace with increasing data volumes.

Overall, the HP Neoview 544530-001 provides organizations with a complete solution for data warehousing that combines powerful performance, extensive storage, advanced data management tools, and scalable architecture, making it an ideal choice for enterprises looking to leverage data for strategic advantage.
Top Page Image Contents