This information can be found for quick reference by typing in
from the command line. Here is a review of keywords which can be used in a schema file, with a few items not previously covered.
field texis_field_name texis_sql_type tag_name_or_expr default
("field" is not required if "stats" is used)
id counter" field for the specified table. Normally the field "id counter" is inserted at the beginning of the table definition. This allows for a unique key field common to all your tables so you can do join operations. As a general rule it is practical to keep the
idfield in your tables. It needn't be called in the
SELECTstatement unless you wish to see it.
Ftimethat couldn't be done otherwise.
Fileis thrown in automatically if no fields are specified to make making simple 3DB databases simpler. If you list other fields, you have to specify the
Filefield to get it imported. Getting the automatic file is the same as saying:
field File varind -
\Fis included in the field.
\Fso that it would occur at start of the next buffer, not end of current buffer. If recdelim is the last tag, it should work without modification.
freadexbuffers. With recdelim, it uses
freadexto sync to the delimiter.
freadexwill normally include the delimiter at the end of the buffer. If readexpr is specified
freadexwill sync to that instead of recdelim. Records may not span buffers. The size of the buffer is 1 megabyte by default. It may be adjusted using the recsize keyword. The program repeats the following till end of buffer:
If your files will fit in memory and the first tag is the delimiter (like mail boxes) you don't need recdelim, just multiple.