Neoview SQL Reference Manual (R2.5)

DAY (datetime-expression)
DAY(datetime-expression)
If there is no space between two items, spaces are not permitted. In this example, no spaces
are permitted between the period and any other items:
myfile.sh
Line Spacing
If the syntax of a command is too long to fit on a single line, each continuation line is indented
three spaces and is separated from the preceding line by a blank line. This spacing
distinguishes items in a continuation line from items in a vertical list of selections. For example:
match-value [NOT] LIKE pattern
[ESCAPE esc-char-expression]
Related Documentation
This manual is part of the HP Neoview customer library.
Neoview Customer Library
The manuals in the Neoview customer library are listed here for your convenience.
• Administration
Information about security features on the Neoview platform, including user
and role management for database and platform users, support for integration
with Lightweight Directory Access Protocol (LDAP) directory servers,
password encryption, and database security.
Neoview User Management and
Security Administration Guide
Information for database administrators and end users of the Neoview
Character Sets product, including rules for defining and managing character
data using SQL language elements, capabilities and limitations of Neoview
client applications, troubleshooting character set-related problems, and enabling
Pass-Through mode in the ISO88591 configuration.
Neoview Character Sets
Administrator's Guide
Introduction to the Neoview database, database users and IDs, database
management, and management tools.
Neoview Database
Administrator’s Guide
Information about how to use stored procedures that are written in Java within
a Neoview database.
Neoview Guide to Stored
Procedures in Java
Information about reviewing query execution plans and investigating query
performance of Neoview databases.
Neoview Query Guide
Information about processes and commands for loading data into your
Neoview platform or extracting data from it.
Neoview Transporter User Guide
— README for the HP Neoview Windows Client Package
— README for the HP Neoview Transporter Java Client
README files for installing
Administration client products
• Management
Help topics that describe how to use the HP Database Manager client to monitor
and manage a Neoview data warehousing platform.
HP Database Manager (HPDM)
Online Help
Information for database administrators about how to monitor and manage
a Neoview data warehousing platform using the HP Database Manager.
HP Database Manager (HPDM)
User Guide
22