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

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-3

ADD DEFINE Command

Considerations for ADD DEFINE

Examples of ADD DEFINE

The ADD DEFINE command creates a new DEFINE in the current MXCI session.

(ADD DEFINE is similar to the TACL command ADD DEFINE and the OSS shell

command add_define.)

You can use defines only for SQL/MP objects.

You can use ADD DEFINE only within an MXCI session.

define

is the name for the new DEFINE. To change an existing DEFINE, use the ALTER

DEFINE command; define cannot be the same as an existing DEFINE name.

See ALTER DEFINE Command on page 4-5.

A DEFINE name must begin with an equal sign (=) followed by a letter. The name

is not case-sensitive and can be up to 24 characters, including alphanumeric

characters and underscores (_).

A DEFINE name must not include a reserved word. Otherwise, you cannot select

data using the DEFINE name of the table, view, or partition. See Appendix B,

Reserved Words.

CLASS MAP

specifies that the DEFINE name define is associated with the name of a table,

view, or partition. Use the DEFINE name in SQL statements as the logical name of

an object, altering the DEFINE when you want to point to a different physical entity.

MAP is the default CLASS.

FILE [\node.][[$volume.]subvol.]filename

specifies the Guardian physical name of a table, view, or partition. \node is the

name of a node on a NonStop system, $volume is the name of a disk volume,

subvol is the name of a subvolume, and filename is the name of a Guardian

disk file. If the physical name is not fully qualified, it is expanded by using the

current default node, volume, and subvolume.

The Guardian physical name must not include a reserved word. Otherwise, you

cannot select data using the DEFINE name of the table, view, or partition. See

Appendix B, Reserved Words.

ADD DEFINE define

[,CLASS MAP], FILE [\node.][[$volume.]subvol.]filename