Data Transformation Engine SQL/MX Adapter Reference Guide

SQL/MX Adapter Reference Guide

Chapter 1 - NonStop SQL/MX Adapter

This chapter introduces the NonStop SQL/MX adapter. You can use the adapter

with the Command Server or Mercator Tuxedo Service.

Overview

Use the NonStop SQL/MX adapter for HP NonStop™ ZLE (Zero Latency Enterprise)

to access and manipulate data contained in databases that are NonStop SQL/MX

data sources. The NonStop SQL/MX adapter is available as part of the Mercator

product on the HP NonStop ZLE operating system.

The NonStop SQL/MX software is a parallel relational database management

system designed for critical data warehouse and online transaction processing

(OLTP) applications.

This document discusses the requirements for running the database adapters for

NonStop SQL/MX and provides the database-specific information required for

using your specific adapters in your database host environment.

Note Use of the NonStop SQL/MX adapter assumes that the Guardian physical file

names have been properly aliased using the "CREATE SQLMP ALIAS…" command.

For example, the following statement creates a mapping in the MPALIAS table:

CREATE SQLMP ALIAS mycatalog.myschema.mytable

$myvol.mysubvol.mytable;