syntax of, 127

SHOW TIME command, 128 SHOW TIMING command, 129 SHOW VIEWS command

example of, 57 syntax of, 129 SPOOL command examples of, 64 syntax of, 130

Spooling (see Logging output) SQL mode, 92

SQL parameters displaying, 61 resetting, 61 setting, 61

SQL statement breaking across lines, 52 displaying the elapsed time, 54 editing, 87

preparing and executing, 60 repeating, 59, 98

running in a Perl or Python program, 76 running in the Neoview Script interface, 59 running on a Perl or Python command line, 75 running when launching Neoview Script, 48 terminating, 52

SQL statements, supported in Neoview Script ALTER MVGROUP statement, 133 ALTER SYNONYM statement, 133 ALTER TABLE statement, 133

ALTER TRIGGER statement, 133 ALTER VIEW statement, 133 BEGIN WORK statement, 133 COMMIT WORK statement, 133 CREATE INDEX statement, 133

CREATE MATERIALIZED VIEW statement, 133 CREATE MVGROUP statement, 133 CREATE SCHEMA, 133

CREATE SYNONYM statement, 133 CREATE TABLE, 133

CREATE TRIGGER statement, 133 CREATE VIEW statement, 133 DELETE statement, 133

DROP INDEX statement, 133

DROP MATERIALIZED VIEW statement, 133 DROP MVGROUP statement, 133

DROP SCHEMA statement, 133 DROP SYNONYM statement, 133 DROP TABLE statement, 133 DROP TRIGGER statement, 133 DROP VIEW statement, 133 EXECUTE statement, 133 GRANT statement, 133 INSERT statement, 134

LOCK TABLE statement, 134 MAINTAIN command, 134 POPULATE INDEX utility, 134 PREPARE statement, 134 PURGEDATA utility, 134

REORG command, 134 REVOKE statement, 134 ROLLBACK WORK statement, 134 SELECT statement, 134

SET SCHEMA, 134

SET TABLE TIMEOUT statement, 134 SET TRANSACTION statement, 134 UPDATE statement, 134

UPDATE STATISTICS statement, 134 SQL terminator

setting, 54 showing, 54 SQL utilities, 133

SQLPlus look and feel, 36 Standard prompt

customizing, 53 description of, 51 displaying the current time, 53

Synonyms

showing all synonyms in a schema, 57 wild-card search, 124

T

Tables

showing all tables in a schema, 56 wild-card search, 128

TDM_Default_DataSource, 46 Teradata look and feel, 36 Timeout, idle session, 53 Transaction, example of, 64 Type 4 driver

See JDBC driver, 26

U

UNIX launch file, location of, 34 UPDATE STATISTICS statement

description of, 134 example of, 76

User profile

setting _JAVA_OPTIONS, 39

setting login environment variables, 74 setting the PATH, 26, 44

Utilities, 133

V

VERSION command, syntax of, 131 Views

showing all views in a schema, 57 wild-card search, 129

W

Wild-card characters, 116 Wild-card search

materialized views, 117 schemas, 121 synonyms, 124 tables, 128

views, 129

Windows launch file, location of, 34

140 Index

Page 139 Page 141
Page 140
Image 140
HP NEOVIEW 544530-001 manual SET Schema
Page 139 Page 141

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