Connection - what is that?
Connection stores information
about text file (such as file name, file type, fields structure etc.) into
separate file with “tmc” extension. Once created it can be used as part of the
TMQL (SQL like query language) queries to:
SELECT – view data;
UPDATE – change values of the individual fields;
INSERT – insert single line or selected number of rows
from another file;
DELETE - specified number of lines from the file.