1 9/29/88 store, s
2
3 Syntax: store table_name column_values -control_args
4
5
6 Function: adds new rows to a designated database table.
7
8
9 Arguments:
10
11 table_name
12 is the name of the non-temporary table to which rows are to be
13 added.
14
15 column_values
16 the column values for the new row to be added DEFAULT -- requests
17 the column values individually by name unless -input_file is
18 specified.
19
20
21 Control arguments:
22
23 -brief, -bf specifies that column_values are not to be verified
24 DEFAULT -- the user is requested to verify the correctness of the
25 column_values prior to the store unless -input_file is specified.
26
27 -column_delimiter X, -cdm X
28 where X is a single ascii character which will be used to delimit
29 the column values. If this control argument isn't specified the
30 default column delimiter is a blank.
31
32 -input_file pathname, -if pathname
33 specifies the name of the file which contains the input data.
34
35
36 -no_progress, -npg
37 specifies that progress messages should not be printed. DEFAULT
38
39 -no_warning, -no_warn
40 specifies that warning messages should not be printed when storing
41 the tuple results in a conversion error or duplicate tuple error.
42
43 -progress N, -pg N
44 specifies that a progress message should be printed after N tuples
45 have been processed, where N is any positive integer. If N is not
46 specified the default is to print a progress message after 1000
47 tuples.
48
49
50 -row_delimiter X, -rdm X
51 where X is a single ascii character which will be used to delimit
52 the row values. If this control argument isn't specified the
53 default row delimiter is the newline character.
54
55 -warning, -warn
56 specifies that warning messages are printed when storing the tuple
57 results in a conversion error or duplicate tuple error. DEFAULT
58
59
60 Examples:
61
62 store employee -if employee_data
63 store employee -if employee_data -cdm X -rdm Y