Command Reference Guide

MXCS Commands and Objects

SQL/MX Connectivity Service Administrative Command Reference—526350-005

2-5

General MXCS Administrative Command Syntax

COMMAND

is listed in Valid Command and Object Type Pairs on page 2-3.

obj-type

is one of the objects listed in Valid Command and Object Type Pairs on page 2-3.

obj-name

is a string that defines the object to be acted upon (with its syntax described in

Object Name Components on page 2-5). Object name (obj-name) is optional if

the previous command acted on the same object. It can also be a subcomponent

of the previously addressed object because the library retains the last object name

and uses this name to complete the current object name, if needed. An error

occurs if an object name is not provided and there is no default. A comma or

semicolon delimits an object name.

attribute

is a keyword-value pair in the form of keyword [value] that further specifies

the desired action. Use either a keyword alone or a keyword followed by a value

with a comma or semicolon delimiting an attribute. Enclose in single or double

quotes values containing a space, quote, comma, or semicolon. Keyword can be

lowercase, uppercase, or mixed uppercase and lowercase. The value can be an

integer, key value, SQL string literal (requires single quotes), or an SQL identifier

(permits double quotes to protect lowercase or special characters). To specify

several attributes, separate each one with a comma. Duplicating an attribute

causes an error.

Command Syntax Case

Command syntax is case-sensitive only when enclosed in single or double quotes.

Object Name Components

An object name has one to four components, separated by periods. No space or

carriage returns are permitted around period separators. The components of an object

name depend on which object type is being addressed. A component can also be

defaulted to the last specified value on an earlier command. Some commands permit

the asterisk (*) wild card to be used as a component name.

COMMAND obj-type [obj-name][, attribute]...;