HP Integrity NonStop H-Series Guida Utente Scaricare il pdf (Pagina 258)

HP NonStop Shadowbase Command Definitions

Database Specification Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

249

where the numeric field is delimited by “” characters.

MXTARGETTABLE fully-qualified-table-ansiname

Initial Changed

Version Version Values Default Value Specifications Alter

5.000 None fully-qual-table-ansiname No

This parameter specifies the fully qualified ansiname of the destination

SQL/MX table. Fully qualified table names include the catalog, schema,

and table. This parameter replaces the TARGETFILE parameter for

SQL/MX replication only, and allows for the larger table ansinames to be

specified. Wildcarded filesets are not supported with this parameter at this

time.

MXTARGETTABLE, MXPATHNAME, or PATHNAME must be specified

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

ORDERCOLSFORDELS {ON}

{OFF}

Initial Changed

Version Version Values Default Minimum Maximum Alter

5.001 OFF OFF ON No

Related to SQL delete statements sent to the HP Shadowbase Other

Servers associated with a DBS object, the ORDERCOLSFORDELS

parameter indicates that the CONS should order the statement column list

and data based upon the order of the key columns in the target schema

(or source schema if there is no TARGETFILE parameter), regardless of

the order of the user exit “puts”. Because there is additional overhead

over the pre-5.001 release to do this, the default is OFF. Note that if user

exit “puts” are done in an arbitrary order for a particular DBS user exit, it

might be better overall to enable this feature, particularly if there are many

statements being cached by an HP Shadowbase Other Servers for all

DBS objects. Also, take note that this parameter is not considered if the

TACL parameter SBCONSORDERCOLS is set to 0 (zero).

PATHNAME name

Initial Changed

Version Version Values Default Value Specifications Alter

3.900 4.092 None Valid Open Server Table Name No

When using MAPFROMSOURCE the file name replacement rules

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

Nessun commento

HP Integrity NonStop H-Series Guida Utente Pagina 258