Guardian Procedure Calls Reference Manual (G06.25+)

Guardian Procedure Calls (F)
Guardian Procedure Calls Reference Manual—522629-013
5-10
FILE_ALTERLIST_ Procedure
<0> =
1
means a null value is specified.
<1> =
1
means the key is unique. If an attempt is
made to insert a record that duplicates an
existing value in this field, the insertion is
rejected with an error 10 (duplicate
record).
<2> =
1
means that automatic updating is not
performed on this key.
<3> =
0
means that alternate-key records with
duplicate key values are ordered by the
value of the primary-key field. This
attribute has meaning only for alternate
keys that allow duplicates.
=
1
means that alternate-key records with
duplicate key values are ordered by the
sequence in which those records were
inserted into the alternate-key file. This
attribute has meaning only for alternate
keys that allow duplicates.
<4:15> Reserved (must be 0)
The length in bytes of this item is 12 times the value of item
100.
102 2 Number of alternate-key files. Specifies the number of files that
are to hold alternate-key records. The maximum value is 100;
the default is 0. FILE_ALTERLIST_ does not automatically
create the alternate-key files.
103 * Alternate-file name-length array. An array of INT values, each
giving the length in bytes of the corresponding alternate-file
name found in item 104. The length in bytes of this item is 2
times the value of item 102.
Table 5-2. FILE_ALTERLIST_ Item Codes (page6of9)
Items in this table with a size of 2 bytes are of data type INT. The term “disk file”
applies only to Enscribe files. The term “disk object” applies to Enscribe files and
SQL objects.
Code
Size
(bytes) Description