NonStop Systems Introduction for H-Series RVUs

The Relational Database Management System
NonStop Systems Introduction for H-Series RVUs—540083-001
4-10
Workstation Access to SQL/MX
NonStop Connectivity Services (NonStop MXCS), which enables developers to use the
popular ODBC interface in client applications. This product is commonly used in
decision support and data mining environments, where decision makers typically use
PC tools to extract information from databases for use in making strategic business
decisions.
Figure 4-6 shows the role of the NonStop MXCS in allowing workstations to access
SQL/MX databases.
NonStop MXCS allows client applications developed for the Microsoft Open Database
Connectivity (ODBC) interface to access SQL/MX. Microsoft ODBC is an API for PCs
running in a Windows environment. NonStop MXCS translates the CORE SQL
statements produced by the ODBC API to SQL/MX statements.
The NonStop MXCS enables PC users to take advantage of the many prepackaged
applications that have been written to use ODBC. In addition, developers can create
custom applications that use ODBC calls.
Client applications using the ODBC API can be easily ported from one platform to
another. The application does not require any changes or any knowledge of SQL/MX in
order to access an SQL/MX database. The user simply selects the NonStop ODBC
server, and the translation between the ODBC API and the format required by NonStop
ODBC is automatic. This makes it easy to take advantage of the many off-the-shelf
applications that use ODBC.
The end user of the application does not need any knowledge of SQL syntax; database
queries are constructed simply by clicking the buttons and filling in the blanks on the
graphical user interface.
Figure 4-6. Workstation Access to SQL/MX
Client program
with ODBC
calls
SQL/MX
NonStop host
Employee name:
Percentage increase:
CancelOK
Adjust_Salary
VST049.vsd
Graphical user interface
NonStop
MXCS