| corporate
products
support |
|
SQLXPress Information :  SQLXPress is a Windows based browser-like interface to SQL/MX running on HP Nonstop Servers. Both MX and MP tables are supported. SQLXPress provides::
Database Administration The user can quickly create, alter, or drop SQL/MX and SQL/MP objects such as tables, views, and indexes. In addition, a powerful set of wizards helps you perform complex tasks like splitting a partition, creating a table, or creating a new database. The wizards do much more than simply generate SQL statements. For example: the split partition wizard can calculate the key value required to make the split at a specified percentage of the records. Some functions (for example, populating an index, or splitting a partition) may take a long time to perform. You can instruct SQLXPress to perform these as background tasks, that can be scheduled for execution by NetBatch, or the built-in job scheduling tool. Table Management It is often convenient to browse SQL tables, and to insert, update, or delete rows, especially in a development or testing environment. This is easily accomplished using SQLXPress. The Export data wizard allows you to export data to an SQL table, or a PC file in CSV format. Visual Query Builder The Visual Query Builder lets you quickly create MX or MP queries using familiar graphical operations such as drag and drop. You don't need to type long and complicated commands, or even remember column names - creating even the most complex of queries requires only a few keystrokes or mouse clicks. Once a query has been built, it can be saved for use at a later time. Queries are stored in a NonStop SQL database. Each query has a security string which specifies which users can view, alter, run, and delete the query. The query builder supports run time parameters. Each time the query is run, the user is prompted to supply a value for each parameter in the query. Parameters are usually used in search conditions, this allows the user to select a different set of rows each time the query is run. Reporting A number of reports are included for SQL catalogs. Execution Plan Management Plans for each version of an MX or MP program can be extracted and retained by SQLXPress in a database. The database can be used to produce a number of reports as well as to do historical comparisons. Module Management and Reports SQLXPress keeps a database of relationships between programs and modules. You can browse these relationships online, or produce various reports. DDL Statements SQLXPress can generate DDL statements that describe SQL objects such as tables, view, or indexes. You can edit the DDL text, or save it to a file. Batch Processing SQLXPress can generate scripts to perform SQL operations in batch mode. This is most useful for long-running, or resource intensive operations that must be performed during off-peak times. The scripts can be scheduled for execution using NetBatch or a similar job scheduling tool. Advanced SQL Scripting Language SQLXPresss includes MSL, an advanced SQL scripting language. MSL supports:
Comprehensive Online Help SQLXPress includes an integrated help system that contains task oriented descriptions in addition to descriptions of each product feature. System Requirements PC: Windows Vista, Windows XP, or Windows 2000 Professional (SP2 or later). Internet Explorer version 4 or later. A TCP/IP connection to an HP NonStop system. NonStop System: S series (G06.26 or later), or Integrity Nonstop Series (H04.03 or later), Nonstop SQL/MX (2.1 or later) NonStop SQL/MP (350 or later) for Nonstop SQL/MP table support. TCP/IP |
|
 |
|
| Home Downloads Product FAQs Product Brochures NSK Related Links Contact Us What is a Merlon? |
