HP Integrity NonStop H-Series Guía de usuario descargar pdf (Pagina 272)

HP NonStop Shadowbase Command Definitions

Database Specification Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

263

not allowed (an underscore will be added automatically between the prefix

and the rest of the column name).

SCREENTRANS { ON }

{ OFF }

Initial Changed

Version Version Values Default Minimum Maximum Alter

2.700 OFF OFF ON No

For bi-directional replication when set to ON, indicates that the

SOURCEFILE in this DBS is a TRANSLOG file used for ping-pong

elimination. The SPECTYPE of this DBS should be set to EXCLUDE.

SKIPALLKEYUPDATE { ON }

{ OFF }

Initial Changed

Version Version Values Default Minimum Maximum Alter

3.960C OFF OFF ON No

The Consumer can be configured to disregard an SQL update statement

that has no "set values". This can occur if the DBS UPDATEDUPLICATE

parameter is set ON for a table that only has key columns or user exit

processing results don't provide any "set values". Note that pre-3.960C

versions of the Consumer will abend with an "illegal SQL syntax" EMS

message if this occurs. Also, note that SQL compressed updates

resulting in no "set values" are already skipped automatically by the

Consumer without any warning message.

Set the DBS object parameter SKIPALLKEYUPDATE ON to enable this

feature. To disable it, set SKIPALLKEYUPDATE to OFF, the default

setting.

Note: If SKIPALLKEYUPDATE is ON, an SQL update statement results

with no "set values", and the CONS WARNINGS parameter is set

to ON, the Consumer reports an EMS warning to indicate that the

event has been skipped. If this scenario occurs and

SKIPALLKEYUPDATE is OFF, the Consumer reports the "illegal

SQL syntax" EMS message and abend.

Note: Avoid this no "set values" anomaly by setting UPDATEDUPLICATE

to OFF for tables where all of the columns are part of the primary

key.

SKIPFATALIOERR {ON}

{OFF}

Initial Changed

1 2 ... 267 268 269 270 271 272 273 274 275 276 277 ... 345 346

Sin comentarios

HP Integrity NonStop H-Series Guía de usuario Pagina 272