HP Integrity NonStop H-Series Uživatelská příručka stáhnout pdf (Strana 257)

HP NonStop Shadowbase Command Definitions

Database Specification Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

248

MXPARTNAMES ( partition-ansiname [,partition-ansiname] ... )

Initial Changed

Version Version Values Default Value Specifications Alter

5.000 None partition-ansiname, .. No

Specifies a list of one or more partitions of a SQL/MX table to be included

or excluded. If not specified, all partitions are selected for inclusion or

exclusion when an MXSOURCETABLE is specified for a DBS object. The

specified partitions must be fully qualified ansinames, and wildcarding of

the partition ansinames is not supported.

MXPATHNAME path-ansiname

Initial Changed

Version Version Values Default Value Specifications Alter

5.000 None path-ansiname No

This parameter functions similar to the PATHNAME DBS parameter, but

allows for larger ansinames to be specified and is only used for replication

of SQL/MX tables.

MXTARGETTABLE, MXPATHNAME, or PATHNAME must be specified

for each INCLUDE spec DBS with an SQL/MX source. Note that

MXPATHNAME and PATHNAME are mutually exclusive.

MXSOURCETABLE fully-qualified-table-ansiname

Initial Changed

Version Version Values Default Value Specifications Alter

5.000 None fully-qual-table-ansiname No

Identifies the fully qualified name of the source table to be included or

excluded. All of the catalog name, schema name, and table name must

be supplied. This parameter functions similar to the SOURCEFILE

parameter, but for use with SQL/MX tables only, and allows for the longer

ansiname supported for these table names. Wildcarded filesets are not

supported for SQL/MX at this time.

Note: The MXSOURCETABLE has limitations which exist when the

catalog or schema are numeric, i.e., CAT.1234.MX_TABLE_NAME, note

the schema name is all numeric. For MXSOURCETABLE parameter, you

must enter the value

MXSOURCETABLE CAT.”1234”.MX_TABLE_NAME

1 2 ... 252 253 254 255 256 257 258 259 260 261 262 ... 345 346

Žádné komentáře

HP Integrity NonStop H-Series Uživatelská příručka Strana 257