12-5
Table Maintenance is specified in the DATA ID field while programming
the TriCoder:
DATA ID entry
description
M1M
data maintenance on table 1
M2M
data maintenance on table 2
M3M
data maintenance on table 3
Table Maintenance file format
The file format for a table used for maintenance is similar to that used by
table data validation in that it uses a header record to describe the table
format to the TriCoder. The header consists of at least 11 characters plus a
comment or reference name. The table maintenance header uses the
following format:
aaxbbxccxddcomment
Position
data allowed
description
x
U 0r F
U indicates field is UPDATABLE
F indicated field is FIXED
aa
01-20
determines the data length of the key field
xbb
x00-x20
determines data length of field #2, use x00 if field is
not present
xcc
x00-x20
determines data length of field #3, use x00 if field is
not present
xdd
x00-x20
determines data length of field #4, use x00 if field is
not present
comment
1-15
alphanumeric
name of file or comment used for internal use; this
field is not used by the TriCoder.
Lets say we wanted to create a file that had a 5 digit item number (the key
field), a Fixed 16 character description, an Updatable 6 digit price, an
Updatable 4 digit quantity count and a file reference of INVENTORY. The
header for such a file would look like this:
05F16U06U04INVENTORY
The entire file might look something like this:
05F16U06U04INVENTORY
11111TWINKIES - 4OZ $1.39 21
22222CANDLES - 3FEET $10.95 180
33333SALMON, SOCKEY12 $5.95 48
Ctrl Z (ASCII 26)
