HP Integrity NonStop H-Series Betriebsanweisung PDF herunterladen (Seite 281)

HP NonStop Shadowbase Command Definitions

Database Specification Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

272

USEREXITPREREAD { ON }

{ OFF }

Initial Changed

Version Version Values Default Minimum Maximum Alter

3.940 OFF OFF ON No

Set this to ON to make the target record available to the user exit. When

set to ON, HP Shadowbase will read and lock the target record when

UPDATES and DELETES are being replicated. A user exit can then

access the data via the SBGETTARGETRECORD (for Enscribe) or

SBGETSQLTARGETCOLUMN (for SQL) API functions to obtain the target

record content. This is useful for certain types of live-live replication. See

the HP Shadowbase Programming Manual for more information on user

exits. By default, USEREXITPREREAD is set to OFF.

USEREXITPREREADI { ON }

{ OFF }

Initial Changed

Version Version Values Default Minimum Maximum Alter

3.961 OFF OFF ON No

When set to ON, the Consumer will attempt to pre-read the target record

before USRXPROCESS is called. User exits can then call the

SBGETTARGETRECORD (for Enscribe) or

SBGETSQLTARGETCOLUMN (for SQL) API functions to obtain the target

record content for INSERT operations. See the HP Shadowbase

Programming Manual for more information on user exits. The default for

USEREXITPREREADI is OFF.

USERGETSINORDER {ON}

{OFF}

Initial Changed Default

Version Version Value Minimum Maximum Alter

5.001 OFF OFF ON No

Starting with version 5.001, a more efficient binary type lookup is used for

user exit “gets” for SQL/MP and SQL/MX source tables (to get column

data) when an arbitrary order is used in the user exit code for “gets”. This

lookup is globally enabled (for all DBS objects) if the CONS detects any

user exit doing “gets” in non-column sequence for a source table.

However, some user exits are efficiently coded to do the “gets” in column

sequence and it may be more efficient to use the pre-5.001 lookup. The

DBS USERGETSINORDER parameter can be set to ON to have the

1 2 ... 276 277 278 279 280 281 282 283 284 285 286 ... 345 346

Keine Kommentare

HP Integrity NonStop H-Series Betriebsanweisung Seite 281