1 9/29/88 store_from_data_file, sdf
2
3 Syntax: store_from_data_file table_name -control_args
4
5
6 Function: reads data from a file and loads it into the specified
7 table.
8
9
10 Arguments:
11
12 table_name
13 is the name of the table defined in the open model or submodel.
14
15
16 Control arguments:
17
18 -column_delimiter X, -cdm X
19 where X is a single ascii character which will be used to delimit
20 the column values. If this control argument isn't specified the
21 default column delimiter is the tilde.
22
23 -input_file pathname, -if pathname
24 specifies the name of the file which contains the input data.
25
26 -no_progress, -npg
27 specifies that progress messages should not be printed. DEFAULT
28
29 -no_warning, -no_warn
30 specifies that warning messages should not be printed when storing
31 the tuple results in a conversion error or duplicate tuple error.
32
33
34 -progress N, -pg N
35 specifies that a progress message should be printed after N tuples
36 have been processed, where N is any positive integer. If N is not
37 specified the default is to print a progress message after 1000
38 tuples.
39
40 -row_delimiter X, -rdm X
41 where X is a single ascii character which will be used to delimit
42 the row values. If this control argument isn't specified the
43 default row delimiter is the newline character.
44
45 -warning, -warn
46 specifies that warning messages are printed when storing the tuple
47 results in a conversion error or duplicate tuple error. DEFAULT
48
49
50 Notes:
51
52 One level of quotes are removed from each column value if present.
53
54
55 Examples:
56
57 store_from_data_file employee -if employee_data
58 store_from_data_file employee -if employee_data -cdm X -rdm Y