HP NonStop G-Series Guide de l'utilisateur télécharger pdf (Page 32)

MXCS Commands and Objects

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

2-4

Fields or Tokens in Commands

All fields or tokens in a command belong to one of these types:

Generally, only these SQL types can be enclosed in quotes or split across multiple

lines. Splitting requires quotes and the CONCAT operator.

Keyword Single word without quotation marks, uppercase or lowercase

(not case-sensitive), alphanumeric characters (A through Z or a

through z, plus 0 through 9). Called key value when used as a

value of an attribute.

Number Single word, numeric characters (0 through 9) with sign (+ or -);

no spaces and no commas.

System name Single word beginning with a backslash (\), uppercase or

lowercase (not case-sensitive), alphanumeric characters (A

through Z or a through z, plus 0 through 9).

Process name Single word beginning with dollar sign ($), uppercase or

lowercase, alphanumeric characters (A through Z or a through

z, plus 0 through 9).

SQL identifier Single word, uppercase or lowercase, unless within optional

double quotes (“), and used for object types DS and EVAR

components. With double quotes, the character set expands to

include spaces, tabs, punctuation, and lowercase alphabetic

letters. See the Identifiers topic in the SQL/MX Reference

Manual for an explanation of SQL identifiers.

Unlike with a true SQL identifier, MXCS administrative

commands accept regular identifiers containing special

characters in unquoted strings, except token separators. Errors

for leading or trailing space characters in a name are reported.

SQL string literal Requires single quotes (‘), is single or multiword, is case-

sensitive unless noted otherwise in the specific command,

permits all printable characters, and is used only for attribute

values. See the Literals topic in the SQL/MX Reference Manual

for an explanation of SQL string literals.

Unlike a true SQL string literal, MXCS administrative

commands do not accept the optional leading character set

identifier and the empty string literal. But these fields accept

leading and trailing space in the string.

1 2 ... 27 28 29 30 31 32 33 34 35 36 37 ... 102 103

Pas de commentaire

HP NonStop G-Series Guide de l'utilisateur Page 32