SQL>

For more information, see the “/ Command” (page 82), “RUN Command” (page 100), or “REPEAT Command” (page 98).

Preparing and Executing SQL Statements

You can prepare, or compile, an SQL statement by using the PREPARE statement and later execute the prepared SQL statement by using the EXECUTE statement.

•“Preparing an SQL Statement” (page 60)

•“Setting Parameters” (page 61)

•“Displaying the Parameters of the Session” (page 61)

•“Resetting the Parameters” (page 61)

•“Executing a Prepared SQL Statement” (page 62)

Preparing an SQL Statement

Use the PREPARE statement to compile an SQL statement for later execution with the EXECUTE statement. You can also use the PREPARE statement to check the syntax of an SQL statement without executing the statement. For example, this PREPARE statement compiles a SELECT statement named empsal and detects a syntax error:

SQL>prepare empsal from +>select salary from employee +>where jobcode = 100;

***ERROR[4082] Table, view or stored procedure NEO.INVENT.EMPLOYEE does not exist or is inaccessible.

***ERROR[8822] The statement was not prepared.

SQL>

You can then correct the syntax of the SQL statement and prepare it again:

SQL>prepare empsal from

+>select salary from persnl.employee +>where jobcode = 100;

--- SQL command prepared.

To specify a parameter to be supplied later, either in a SET PARAM statement or in the USING clause of an EXECUTE statement, use one of these types of parameters in the SQL statement:

•Named parameter, which is represented by ?param-name

•Unnamed parameter, which is represented by a question mark (?) character

For example, this prepared SELECT statement specifies unnamed parameters for salary and job code:

SQL>prepare findemp from +>select * from persnl.employee +>where salary > ? and jobcode = ?;

--- SQL command prepared.

This PREPARE statement prepares another SELECT statement named empcom, which has one named parameter, ?dn, for the department number, which appears twice in the statement:

SQL>prepare empcom from

+>select first_name, last_name, deptnum +>from persnl.employee

+>where deptnum <> ?dn and salary <= +>(select avg(salary)

+>from persnl.employee +>where deptnum = ?dn);

--- SQL command prepared.

For the syntax of the PREPARE statement, see the Neoview SQL Reference Manual.

60 Running Commands Interactively in the Neoview Script Interface

Page 59 Page 61
Page 60
Image 60
HP NEOVIEW 544530-001 manual Preparing and Executing SQL Statements, Preparing an SQL Statement
Page 59 Page 61

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