load@"load"
This form is almost always used with the data in a file.
Fixed-format loading requires a format definition block
that describes the position and format of each
column to be loaded.
It is also usually in a file and looks like
<"format"
<line> <position> <column_name> <format>
&vellip#vdots;
"end"
〈"format"〉
where <line> is 1 for the first input record of a row, 2 for
the next input record, etc.
<Position> is the starting character position in the record
for the data. Data formats are described in figure .
You may enter a null field ("' '") in place of the <column_name> and
<format> to cause Rim to skip an input line.
Figure:
Fixed-form loading of Sample database.
Note that the format file is normal
Rim form but the data file is not.
|
Begin formatted loading with
<"load" <table> "from" <data_file> "using" <format_file>
where the data is in file <data_file> and the format block
is in file <format_file>. The latter may be ``"terminal"''
if you want to enter the format block online.
If both filenames are the same Rim will first read the
format and then the data from the same file.
See the notes on filenames in appendix .
Figure shows an the input that loaded
the "measures" table.
load@"load"|)