SQL/MX 2.x Reference Manual (H06.04+)

Introduction

HP NonStop SQL/MX Reference Manual—540440-003

1-3

Session Attributes

Within an MXCI session, the tasks you perform are affected by these attributes of the

session:

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.

Parameters Parameter values set by the SET PARAM command to

substitute for parameter names when a statement executes

Prepared Statements Statements compiled for execution later in the session

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