HP Integrity NonStop H-Series Guide de l'utilisateur télécharger pdf (Page 234)

HP NonStop Shadowbase Command Definitions

Database Specification Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

225

See the CONTROL TABLE statement in the NonStop SQL manual for all

possible control statement options.

SET DBS CONTROLTABLEEXT (<control clause>)

Note: This parameter should not be used to specify the tablelock clause,

as it is already handled based upon the setting of the

CONTROLTABLELOCK parameter.

CONTROLTABLEEXT<n> (<control clause>)

Initial Changed

Version Version Values Default Alter

4.040C None No

This parameter set has been superseded by the single

CONTROLTABLEEXT parameter. If CONTROLTABLEEXT is specified

these parameters will be ignored.

The DBS CONTROLTABLEEXT1, CONTROLTABLEEXT2, and

CONTROLTABLEEXT3 parameters can be used to issue custom SQL

CONTROL TABLE statements against a target table during startup of the

Consumer. Each parameter is 60 bytes in length and must be entered

with starting and ending parenthesis (). The texts of these three

parameters are directly concatenated together without the parenthesis, so

trailing spaces should be added where appropriate.

For example, the following will disable sequential table access for reads,

inserts, and updates. See the CONTROL TABLE statement in the

NonStop SQL manual for all possible control statement options.

SET DBS CONTROLTABLEEXT1 (SEQUENTIAL READ OFF ) [note extra space]

SET DBS CONTROLTABLEEXT2 (SEQUENTIAL INSERT OFF ) [note extra space]

SET DBS CONTROLTABLEEXT3 (SEQUENTIAL UPDATE OFF)

Note: These parameters should not be used to specify the tablelock

clause as it is already handled based upon the setting of the

CONTROLTABLELOCK parameter.

CONTROLTABLELOCK { ON }

{ OFF }

Initial Changed

Version Version Values Default Minimum Maximum Alter

2.000 OFF OFF ON No

1 2 ... 229 230 231 232 233 234 235 236 237 238 239 ... 345 346

Pas de commentaire

HP Integrity NonStop H-Series Guide de l'utilisateur Page 234