Allows you to define or delete storage maps, storage areas, and
indexes.
When you include a metadata statement within the IMPORT
statement, the metadata statement is NOT terminated with a
period.
(B)0[mmetadata-options =
qwqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqq>
x tq> define-storage-map-statement qqqqqqqqqqqqqqqqqqqqqqqqqqqu x
x tq> delete-storage-map-statement qqqqqqqqqqqqqqqqqqqqqqqqqqqu x
x tq> define-storage-area-clause qqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
x tq> [4mDELETE[m [4mSTORAGE[m [4mAREA[m qqqqqqqqqqqqqq> storage-area-name qqu x
x tq> [4mSEGMENTED[m [4mSTRING[m [4mSTORAGE[m [4mAREA[m IS q> storage-area-name qqu x
x tq> define-index-statement qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
x mq> delete-index-statement qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj x
mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
1 – define-storage-map
(B)0[mdefine-storage-map-statement =
[4mDEFINE[m [4mSTORAGE[m [4mMAP[m qqqqqqqqqqq> map-name qqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqj
mqwqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqwqqqqqqqqqqqqk
mq> [4mDESCRIPTION[m IS /* text */ qqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqq> [4mFOR[m qqq> relation-map-clause qqqqqqqqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqj
mqqq> [4mEND[m qwqqqqqqq>qqqqqqqwqq> STORAGE MAP qq>
mq> map-name qqqj
This statement defines a new storage map replaces the definition
of an existing storage map contained in the interchange file.
For more information on the DEFINE_STORAGE_MAP statement, see the
top-level help topic DEFINE_STORAGE_MAP.
2 – delete-storage-map
(B)0[mdelete-storage-map-statement =
[4mDELETE[m [4mSTORAGE[m [4mMAP[m qqqqq> map-name qqqqq>
This statement prevents use of a storage map definition from the
interchange file. The relation that would have used the storage
map definition is placed in the system default storage area.
For more information on the DELETE_STORAGE_MAP statement, see the
top-level help topic DELETE_STORAGE_MAP.
3 – define-storage-area
(B)0[mdefine-storage-area-clause =
qqqq> [4mDEFINE[m [4mSTORAGE[m [4mAREA[m qqwqqqq> storage-area-name qqqqwqqqqqqk
mqqqq> RDB$SYSTEM qqqqqqqqqqqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqq> [4mFILENAME[m qqqqq> file-spec qqwqqqqqqqqqqqq>qqqqqqqqqqqqqwqqqk
mq> storage-area-options qqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqq> [4mEND[m qqqqqqqwqqqqqqqqqq>qqqqqqqqqqqwq> STORAGE AREA qqqq>
tq> storage-area-name qu
mq> RDB$SYSTEM qqqqqqqqj
The define-storage-area-clause adds a new storage area or
replaces the definition of an existing storage area contained
in the interchange file.
For more information on the define-storage-area-clause, see the
help topic for DEFINE_DATABASE Format define-storage-area.
4 – DELETE_STORAGE_AREA
Prevents a storage area that was defined in the interchange file
from being created in the new database. You must also delete or
redefine all storage maps and indexes that refer to this storage
area. You cannot delete the RDB$SYSTEM storage area.
5 – SEGMENTED_STRING
The name of the storage area that will hold all segmented
strings. You can only specify the SEGMENTED STRING STORAGE AREA
clause in a multifile database. In a multifile database, if you
do not explicitly define a storage area for segmented strings,
they will be stored in the default storage area (RDB$SYSTEM).
The page format for the segmented string storage area can
be UNIFORM or MIXED. However, Rdb recommends that if you
store segmented strings in a MIXED storage area, the storage
area contain only segmented strings.
6 – define-index
(B)0[m[4mDEFINE_INDEX[m name wqqqqqqqqqqqqqqq>qqqqqqqqqqqqwq> FOR relation-name qk
m> [4mDESCRIPTION[m IS /* text */ j x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqwqqqqqqqqq>qqqqqqqqqqwqqqqwqqqqqqqqqqq>qqqqqqqqqqqqwqqqqqqqk
m> duplicates-clause j m> index-storage-clause qj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqwqqqqqqqqqqqqq>qqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqk
tq> [4mTYPE[m IS qqwqqq> [4mHASHED[m qqqj x x
x mqqq> [4mSORTED[m qq> sorted-index-param-list qqqu x
mqqqqqqqqqqqqqq> sorted-index-param-list qqqqqqqqqqqqqqqqqj x
lqqqqqqqqqqqqqqqqqqqqqqqqq . <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mwq> field-name qqwqwqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqwqwqqwqk
x x t> [4mASCENDING[m qqqqqqqqqqqqqqqqqqqqqqqu x x x
x x t> [4mDESCENDING[m qqqqqqqqqqqqqqqqqqqqqqu x x x
x x t> [4mSIZE[m [4mIS[m n qqqqqqqqqqqqqqqqqqqqqqqu x x x
x x m> [4mMAPPING[m [4mVALUES[m lo-val [4mTO[m hi-val qj x x x
x mqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqj x x
mqqqqqqqqqqqqqqqqqqqqqqqqq . <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqq . <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mq> [4mEND[m wqqq>qqqqw> INDEX q>
mq> name j
This statement defines a new index or replaces an existing index
definition contained in the interchange file.
For more information on the DEFINE INDEX statement, see the top
level help topic DEFINE_INDEX.
7 – delete-index
(B)0[mdelete-index-statement =
[4mDELETE[m [4mINDEX[m qq> index-name qq>
This statement prevents creation of an index defined in the
interchange file.
For more information on the DELETE INDEX statement, see the top-
level help topic DELETE_INDEX.