SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Introduction

HP NonStop SQL/MX Reference Manual—523725-004

1-3

Entering a Command

Each statement or command entered through MXCI must be terminated by a

semicolon (;). You can include several statements or commands on the same line

provided that each one is terminated by a semicolon.

Case Sensitivity

In MXCI, statements and commands can be in uppercase, lowercase, or mixed case

letters. All parts of statements and commands are case-insensitive except for parts that

you enclose in single- or double-quotes.

Breaking the Command Line

You can continue any statement or command over multiple lines, breaking that

statement or command at any point except within a word, a numeric literal, or a

multicharacter operator (for example, >=). When you break a string literal, you must

use the concatenation operator (||). A semicolon terminates a statement or command

that is broken over several lines.

The maximum length of a MXCI statement in NonStop SQL/MX is 4096 characters,

without any new lines or embedded carriage returns.

SQL Comments

You can include comments in MXCI input lines. Comments are useful for describing a

statement or command. You can also use comments to disable specific statements or

commands without removing them from the source code, such as for debugging

purposes.

To indicate that an MXCI line is a comment, precede the comment with two hyphens

(--):

-- comment-text

Transactions Transaction modes set by the SET TRANSACTION statement

for the next transaction in the session

NAMETYPE value Attribute value ANSI or NSK that determines whether partially-

qualified object names in SQL statements executed in the

session are logical names (ANSI) or Guardian physical names

(NSK).

Default Names Default logical catalog and schema names for unqualified

names in preparable statements and set by the SET CATALOG

and SET SCHEMA statements respectively

Default physical volume and subvolume names for unqualified

names in preparable statements and set by the SET MPLOC

statement