SET DEFAULT SINGLE TABLE STORAGE UNIT

Description

The SET DEFAULT SINGLE TABLE STORAGE UNIT syntax is used to set default single table storage unit.

Syntax

Grammar Railroad diagram

SetDefaultSingleTableStorageUnit ::=
  'SET' 'DEFAULT' 'SINGLE' 'TABLE' 'STORAGE' 'UNIT' singleTableDefinition
singleTableDefinition ::=
  '=' (storageUnitName | 'RANDOM')
storageUnitName ::=
  identifier

Supplement

• STORAGE UNIT needs to use storage unit managed by RDL. The RANDOM keyword stands for random storage.

Example

• Set a default single table storage unit

SET DEFAULT SINGLE TABLE STORAGE UNIT = ds_0;

• Set the default single table storage unit to random storage

SET DEFAULT SINGLE TABLE STORAGE UNIT = RANDOM;

Reserved word

SET, DEFAULT, SINGLE, TABLE, STORAGE, UNIT, RANDOM

Related links

• Reserved word