Definitions and Records
Data Definition Language (DDL) Reference Manual — 426798-002
5- 16
File-Creation Syntax
CODE { file-code | constant-name }
assigns a file code to a file. The default setting for a file code is 0.
file-code
is an integer between 0 and 65,535. File codes 100 through 999 are reserved
for use by HP.
constant-name
is the name of a constant in the open DDL dictionary. The constant value must
be a valid file-code value.
{
COMPRESS | DCOMPRESS | ICOMPRESS }
sets index compression or data compression or both. You can specify these
attributes only for key-sequenced files. COMPRESS sets both index and data
compression on, DCOMPRESS sets data compression on, and ICOMPRESS sets
index compression on.
EXT { { extent-size | constant-name } }
{ ( { pri-extent-size | constant-name } ,
{ sec-extent-size | constant-name } ) } }
sets the extent size in pages.
extent-size
is an integer from 1 to 65,535 that specifies the total extent size. For structured
files, the extent size must be a multiple of the file’s BLOCK value; that is, the
extent size in bytes divided by the block size must be an integer. For
unstructured files, the extent size must be a multiple of the file’s BUFFERSIZE
value. For example, if a file’s block size is 4,096, you can specify a primary
extent size of 4, but not 3:
4 x 2048 / 4096 = 2
3 x 2048 / 4096) = 1.5
pri-extent-size
is an integer from 1 to 65,535 that specifies the primary extent size. The default
primary extent size for files created by DDL is 4 pages.
sec-extent-size
is an integer from 1 to 65,535 that specifies the secondary extent size. The
default secondary extent size is 32 pages.
constant-name
is the name of a constant in the open DDL dictionary. The constant value must
be a valid extent-size, pri-extent-size, or sec-extent-size value.
Содержание DDL D40
Страница 36: ...Introduction to DDL Data Definition Language DDL Reference Manual 426798 002 1 14 Examining a Dictionary ...
Страница 66: ...Named Constants Data Definition Language DDL Reference Manual 426798 002 4 10 Standard SPI Constants ...
Страница 230: ...Dictionary Manipulation Statements Data Definition Language DDL Reference Manual 426798 002 8 14 SHOW USE OF Statement ...
Страница 370: ...Dictionary Maintenance Data Definition Language DDL Reference Manual 426798 002 10 24 Converting a Dictionary ...
Страница 456: ...Sample Schemas Data Definition Language DDL Reference Manual 426798 002 B 12 ASSNDDL Statements ...
Страница 470: ...DDL Data Translation Data Definition Language DDL Reference Manual 426798 002 C 14 ...
Страница 528: ...Dictionary Reports Data Definition Language DDL Reference Manual 426798 002 E 8 Requesting Reports ...
Страница 552: ...DDL Alignment Rules Data Definition Language DDL Reference Manual 426798 002 H 4 FIELDALIGN_SHARED8 Alignment Rules ...
Страница 576: ...Index Data Definition Language DDL Reference Manual 426798 002 Index 22 Special Characters ...