Although you can run any of the Neoview Script interface commands with -qor -sql, the @, OBEY, and PRUN commands are the most useful. For a list of supported SQL statements, see Appendix B (page 133).

Example of Running an SQL Statement With -q or -sql

Use -qor -sqlwith the CREATE SCHEMA statement to create a schema when launching the Neoview Script interface:

On Windows, in the Command Prompt window, enter: cd hpnvs-installation-directory\nvscript\bin hpnvs.cmd -q "create schema persnl"

On Linux or UNIX, in the terminal window, enter:

cd hpnvs-installation-directory/nvscript/bin

./hpnvs.sh -q "create schema persnl"

After you enter the SQL statement, the Neoview Script interface launches, prompts you to log in by default (if you did not specify -h, -u, -p, and -dsnon the command line), runs the SQL statement, and then returns to the command prompt:

Host Name/IP Address: sys0101.mylab.mycorp.net:18650

User Name: dba1

Password:

DataSource Name [Admin_Load_DataSource]:

--- SQL operation complete.

C:\install\nvscript\bin>_

Example of Running a Neoview Script Interface Command With -q or -sql

Use -qor -sqlwith the PRUN command to run multiple script files simultaneously from the command line:

On Windows, in the Command Prompt window, enter: cd hpnvs-installation-directory\nvscript\bin hpnvs.cmd -q "prun"

On Linux or UNIX, in the terminal window, enter:

cd hpnvs-installation-directory/nvscript/bin

./hpnvs.sh -q "prun"

After you enter the Neoview Script interface command, the Neoview Script interface launches, prompts you to log in by default (if you did not specify -h, -u, -p, and -dsnon the command line), and runs the command. The parallel run (PRUN) operation prompts you to enter settings and then executes the script files. At the end of the PRUN operation, the Neoview Script interface returns to the command prompt. For more information about the PRUN operation, see “PRUN Command” (page 95).

Running a Script File When Launching Neoview Script

To run a script file when launching Neoview Script, use the -sor -scriptcommand-line parameter.

NOTE: You cannot specify this parameter at the same time as the -qor -sqlparameter.

After you launch the Neoview Script interface with -sor -script, Neoview Script executes the script file. The Neoview Script interface remains open until you enter the EXIT, QUIT, or

48 Launching the Neoview Script Interface

Page 48
Image 48
HP NEOVIEW 544530-001 manual Running a Script File When Launching Neoview Script

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.