JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

JDBC Driver Reference Pages
NonStop System Computing Documents
The following NonStop system computing documents are available in the NonStop Technical Library at BSC.
SQL/MX Connectivity Service Manual—Describes the SQL/MX connectivity service (MXCS) on the NonStop server. This product enables
applications developed for the Microsoft® Open Database Connectivity (ODBC) application programming interface and other connectivity
APIs to use NonStop SQL/MX to access NonStop SQL databases on NonStop systems.
NonStop JDBC Server Programmer's Reference—Describes how to use the JDBC type 3 driver that allows Java programmers to remotely
(from a PC or UNIX machine) develop and debug applications that will be deployed on NonStop servers to access NonStop SQL databases
using SQL/MP or SQL/MX tables.
JDBC Driver for SQL/MX Programmer's Reference—Describes how to use the JDBC Driver for SQL/MX (JDBC/MX), a type 2 driver that
provides Java applications running on NonStop systems with access to NonStop SQL databases through the SQL/MX engine.
SQL/MX documents
SQL/MX Programming Manual for Java—Explains how to use embedded SQL in Java programs to access NonStop SQL databases with
SQL/MX tables.
SQL/MX Guide to Stored Procedures in Java—Describes how to develop and deploy stored procedures in Java (SPJs) in SQL/MX.
SQL/MX Quick Start—Describes basic techniques for using SQL in the SQL/MX conversational interface (MXCI). Also includes
information about installing the sample database.
SQL/MX Reference Manual—Describes SQL/MX language elements (such as expressions, predicates, and functions) and the SQL
statements that can be run in MXCI or in embedded programs. Also describes MXCI commands and utilities.
Notation Conventions
Bold Type
Bold type within text indicates terms defined in the Glossary. For example:
abstract class
Computer Type
Computer type letters within text indicate keywords, reserved words, command names, class names, and method names; enter these
items exactly as shown. For example:
myfile.c
Italic Computer Type
Italic computer type letters in syntax descriptions or text indicate variable items that you supply. For example:
pathname
[ ] Brackets
Brackets enclose optional syntax items. For example:
jdb [options]
A group of items enclosed in brackets is a list from which you can choose one item or none. Items are separated by vertical lines. For
example:
where [threadID|all]
{ } Braces
A group of items enclosed in braces is a list from which you must choose one item. For example:
-c identity {true|false}
| Vertical Line
A vertical line separates alternatives in a list that is enclosed in brackets or braces. For example:
where [threadID|all]
... Ellipsis
An ellipsis immediately following a pair of brackets or braces indicates that you can repeat the enclosed sequence of syntax items any
number of times. For example: