Introduction to Networking for NonStop S-Series Servers

Application Programming With Communications
Products
Introduction to Networking for HP NonStop S-Series Servers—520670-005
3-12
NonStop SQL/MP
NonStop TUXEDO Environment
Through the NonStop TUXEDO product, the TUXEDO environment provides a client-
server model for open applications and the benefits of the HP fundamentals. The
TUXEDO environment provides a standard, easy-to-use API and robust features for
both the administrative and development environments. The TUXEDO API has been
selected by the X/Open Company and UNIX International as a reference technology
for open OLTP application programming.
If the use of standard APIs and portability of programs and programmer skills are
important for your application, for example, or if your existing TUXEDO applications
could benefit from the HP fundamentals, the TUXEDO environment is the choice for
you.
NonStop SQL/MP
HP NonStop SQL/MP is a relational, distributed, database-management system based
on the ANSI-standard Structured Query Language (SQL), which is used both to
describe and to manipulate data. SQL offers conversational and programmatic
interfaces, includes a data dictionary, and permits logical views of the data. It also
includes a report writer (not supported by the SQL/MX version.) NonStop SQL is
integrated into the NonStop Kernel operating system and uses parallel execution to
provide outstanding transaction-processing and query performance along with fault-
tolerance.
You can develop applications using either the traditional HP Guardian services or using
industry-standard services as provided by the HP Open System Services (OSS).
COBOL85 and C programs running in either the Guardian or OSS environment can
concurrently access the same data and be governed by the same concurrency
constraints and transaction controls. The active data dictionary dynamically manages
both Guardian-based and OSS-based programs. Programs from either environment
have equal access to SQL data.
You can also develop applications using the latest in PC and workstation client tools.
NonStop SQL/MP supports a variety of industry-standard client-server APIs such as
ODBC, DAL, EDA/SQL, SQL Server, and SQL*Connect. SQL/MX supports ODBC and
JDBC.
Because many popular client applications are compatible with the APIs, you can, in
many cases, use familiar software tools to access SQL data. Further, business-
oriented end users do not have to know SQL, because HP API products such as the
HP NonStop ODBC Server automatically translate their requests into SQL queries.