Manuals / HP / Computer Equipment / Computer Accessories

HP NEOVIEW 544530-001 manual Using Neoview Script Interface Commands, Case Sensitivity

Models: NEOVIEW 544530-001

1 142
Download 142 pages 61.21 Kb
Page 52
Image 52

You can continue any SQL statement over multiple lines, breaking that statement at any point except within a word, a numeric literal, or a multicharacter operator (for example, <=). To break a string literal in a DML statement, use a concatenation operator (). For more information, see the concatenation operator in the Neoview SQL Reference Manual.

To terminate an SQL statement that spans multiple lines, use the SQL terminator for the session. You can also include several SQL statements on the same command line provided that each one is terminated by the SQL terminator. For more information, see “Setting and Showing the SQL Terminator” (page 54).

Case Sensitivity

In the Neoview Script interface, you can enter SQL statements and Neoview Script interface commands in uppercase, lowercase, or mixed-case characters. All parts of statements and commands are case-insensitive except for parts that you enclose in single-quotes (') or double-quotes (").

Using Neoview Script Interface Commands

The Neoview Script interface commands allow you to customize the Neoview Script interface (for example, by using SET commands) or return information about the interface settings or database objects (for example, by using SHOW commands):

•“Showing the Session Attributes” (page 52)

•“Setting and Showing the Idle Timeout Value for the Session” (page 53)

•“Customizing the Standard Prompt” (page 53)

•“Setting and Showing the SQL Terminator” (page 54)

•“Displaying the Elapsed Time” (page 54)

•“Setting and Showing the Current Schema” (page 55)

•“Limiting the Result Set of a Query” (page 55)

•“Showing Information About SQL Database Objects” (page 55)

•“Displaying Executed Commands” (page 58)

•“Editing and Reexecuting a Command” (page 58)

•“Clearing the Interface Window” (page 58)

•“Obtaining Help” (page 58)

For more information about the Neoview Script interface commands, see Appendix A (page 79).

NOTE: Each Neoview Script interface command must be entered on one line. If you accidentally break a Neoview Script interface command across more than one line, enter the SQL terminator and then reenter the command on one line.

Showing the Session Attributes

To display the attributes and settings of the current Neoview Script session, use the ENV, SHOW SESSION, or SESSION command. For example, this SESSION command displays the session attributes:

SQL>session

 

COLSEP

" "

DATASOURCE

TDM_Default_DataSource

HISTOPT

ALL

IDLETIMEOUT

30 min(s)

LIST COUNT

0 [All Rows]

LOG

OFF

LOOK AND FEEL

BTEQ

MARKUP

RAW

MODE

SQL

PROMPT

SQL>

52 Running Commands Interactively in the Neoview Script Interface

Page 51 Page 53
Page 52
Image 52
HP NEOVIEW 544530-001 manual Using Neoview Script Interface Commands, Case Sensitivity, Showing the Session Attributes
Page 51 Page 53

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.