1 12/20/86 create_relation, crr
2
3 Syntax: crr relation_name rel_attribute_list -control_args
4
5
6 Function: create a new relation in a data base.
7
8
9 Arguments:
10 relation_name
11 is the name of the relation to be created.
12 rel_attribute_list
13 is a list of the attribute names used in the relation. The
14 rel_attribute_list has the syntax of attr_1 attr_2 ... attr_n
15 where "attr_"s are the attribute names of the attributes to be used
16 for the relation. The attribute names that are to make up the
17 primary key of the relation must have an appended "*". The
18 rel_attribute_list cannot be used if the -selection_exp control
19 argument is provided.
20
21
22 Control arguments:
23 -index STR, -ix STR
24 specifies the list of attributes in the relation that are indexed.
25 STR has the syntax of attr_1 attr_2 ... attr_n where "attr_"s are
26 the attribute names of the attributes to be indexed. If the
27 -selection_exp control argument is used, the -index control argument
28 must precede the -selection_exp control argument.
29 -selection_exp STR select_values, -se STR select_values
30 STR is a selection expression that defines relation attributes that
31 are to be created and populated using the data selected by the
32 selection expression. See "help mrds.selection_expressions" for the
33 define_temp_rel selection expression specification. The selection
34 expression must be a separately quoted string with any select_values
35 provided as individual arguments. The -selection_exp control
36 argument, if provided, must be the last control argument.
37
38
39
40
41
42
43