Creates a storage map for a relation.  A storage map associates a
 relation with a particular storage area or areas.  The DEFINE STORAGE
 MAP statement allows you to specify:

  o  Which storage areas the records in a relation will be stored in
  o  Whether an index will be used to choose a target location for
     storing the record
  o  Whether data compression will be enabled when the records are
     stored


 Example:

    RDO>   DEFINE STORAGE MAP JOBS_MAP FOR JOBS
    cont>    STORE WITHIN JOBS
    cont>  END JOBS_MAP STORAGE MAP.

Additional information available:

FormatMoreExamples

 DEFINE STORAGE MAP ───────────> map-name ──────────────┐
 ┌────────────────────────<─────────────────────────────┘
 └──────┬─────────────────────>───────────┬────────────────────┐
        └─> 
D
E
S
C
R
I
P
T
I
O
N typebox (I)typebox (S) typebox (/)typebox (*)  text  */ ──┘                    │
 ┌─────────────────────────────────────────────────────────────┘
 └───> 
F
O
R  ────────────> relation-map-clause ────────────────────┐
  ┌───────────────────────────────<───────────────────────────────┘
  └──────────> 
E
N
D ─────┬───────────────┬─────> typebox (S)typebox (T)typebox (O)typebox (R)typebox (A)typebox (G)typebox (E) typebox (M)typebox (A)typebox (P) ───────> .
                        └─> map-name ───┘

Additional information available:

map-nametextrelation-map-clause

 Specifies the name for the storage map being defined.

 A text string that adds a comment to the storage map definition.

 relation-map-clause =

 ────>  relation-name ──────> typebox (R)typebox (E)typebox (L)typebox (A)typebox (T)typebox (I)typebox (O)typebox (N) ──────────────────┐
  ┌─────────────────────────────<────────────────────────┘
  └──┬──┬──> store-clause ────────────────────────┬──┬──>
     │  ├──> 
P
L
A
C
E
M
E
N
T 
V
I
A 
I
N
D
E
X ──> index-name ──┤  │
     │  └┬──> 
D
I
S
A
B
L
E ──┬─> 
C
O
M
P
R
E
S
S
I
O
N ──────────┘  │
     │   └──> 
E
N
A
B
L
E ───┘                            │
     └──────────────────────────<────────────────────┘

Additional information available:

PLACEMENT_VIA_INDEX

relation-namestore-clauseCOMPRESSION clause

 Specifies the relation to which the storage map will apply.  The
 relation must already be defined and cannot have a storage map
 associated with it.

 store-clause =

 STORE ─┬──> 
W
I
T
H
I
N ─┬──> storage-area-name ────┬─────>──────────┬──>
 ┌──────┘            └───────  typebox (;) <──────────────┘                │
 │                                                               │
 └─────> 
U
S
I
N
G ───┬────> field-name ───┬── 
W
I
T
H
I
N ────>──────┐   │
                  └────────── , ───────┘                     │   │
 ┌───────────────────────────────<───────────────────────────┘   │
 └─┬─>storage-area-name ──>
W
I
T
H 
L
I
M
I
T typebox (O)F─┬> literal ─┬─ typebox (;) ──┬─┐  │
   │                                     └──── , <───┘      │ │  │
   └──────────────────────────<─────────────────────────────┘ │  │
 ┌────────────────────────────<───────────────────────────────┘  │
 │                                                               │
 └────────────────────> storage-area-name ─────────>─────────────┘

Additional information available:

WITH_LIMIT_OF

field-namestorage-area-name

 The names of the fields whose values will be used as limits for
 partitioning the relation across multiple storage areas.

 The name of the storage area you want records stored in.  You must
 define this storage area with the DEFINE DATABASE statement before
 you refer to it in the store clause.

 The maximum value for the index key that will reside in the specified
 storage area.

 The number of literals in this clause must be the less than or equal
 to the number of fields in the USING clause.  Repeat this clause to
 partition the index entries among multiple storage areas.

 When you define a multisegmented index using multiple keys and use
 the STORE USING...WITH LIMITS clauses, if the values for the first
 key are all the same, then set the limit for the first key at that
 value.  By doing this, you insure that the value of the second key
 determines the storage area in which each record will be stored.

 Note that the last storage area you specify CANNOT have a WITH LIMIT
 OF clause associated with it.

 Indicates that Rdb/VMS should attempt to store a record in a way that
 optimizes access to that record via the indicated path.

 If the index named is a hashed index, the storage area named must
 have a MIXED page format.  If the hashed index definition and the
 storage map for the relation designate the same storage area, then
 the record is stored on the same page as the hashed index node.
 Otherwise, Rdb/VMS uses the same relative page within the data
 storage area as the target page.

 If the index named is a sorted index, Rdb/VMS finds the dbkey of the
 next lowest record to the one being stored and uses the page number
 in the dbkey as the target page.

 Specifies whether data compression will be enabled or disabled when
 the records are stored.  ENABLE COMPRESSION is the default.

 You must execute this statement in a read/write transaction.  If
 there is no active transaction and you issue this statement, Rdb/VMS
 starts a read/write transaction implicitly.

 Other users are allowed to be attached to the database when you issue
 the DEFINE STORAGE MAP statement.  However, they are not allowed to
 be using the relation whose storage map is being defined.

 Example 1

 The following statement defines a storage map for the employees
 relation in MF_PERSONNEL.

 DEFINE STORAGE MAP EMPLOYEES_MAP
    DESCRIPTION IS /* EMPLOYEES partitioned by EMPLOYEE_ID */
    FOR EMPLOYEES RELATION
  STORE USING EMPLOYEE_ID
   WITHIN
    EMPIDS_LOW WITH LIMIT OF "00200";
    EMPIDS_MID WITH LIMIT OF "00400";
    EMPIDS_OVER
 END EMPLOYEES_MAP STORAGE MAP.

 Example 2

 The following example shows how to define a storage map that stores
 all records from a relation in the named storage area:


 RDO>  DEFINE STORAGE MAP SALARY_HISTORY_MAP
 cont>  DESCRIPTION IS /* Map for salary history records */
 cont>  FOR SALARY_HISTORY RELATION
 cont>   STORE WITHIN SALARY_HISTORY
 cont> END SALARY_HISTORY_MAP STORAGE MAP.

 This statement stores all the records from the SALARY_HISTORY
 relation into the storage area, SALARY_HISTORY.  SALARY_HISTORY is
 the name of a storage area that was created with the DEFINE DATABASE
 statement.

 Example 3

 The following example uses the PLACEMENT VIA INDEX clause to store
 records in a storage area according to a hashed index:

 RDO>   DEFINE STORAGE MAP DEPARTMENTS_MAP
 cont>    FOR DEPARTMENTS RELATION
 cont>    STORE WITHIN DEPARTMENTS
 cont>    PLACEMENT VIA INDEX DEPARTMENTS_INDEX
 cont>  END DEPARTMENTS_MAP STORAGE MAP.