# # This line (and all lines beginning with '#') are COMMENTS. # # This is a sample BTrieve Supplemental Index (BTS) file. # It allows for the creation of a supplemental index (key) # for Btrieve files in BTFILER. It does the same thing # as the BUTIL -SINDEX function, but with one significant # difference: Error diagnostics are clearer. This removes (I # think) the most significant problem with the BUTIL -SINDEX # process. Someday an interactive utility for this will be part # of BTFILER, but until then, this will have to do... # # Case is not important, and some fields are optional (as # noted in comments). # # This field is the only field possible on the file level section: # # ALTERNATE FILE= OPTIONAL if no alternate key # # # # ALTERNATE FILE=fname, where fname is the name of a file like # UPPER.ALT. This line is optional IF no ALTERNATE=YES # key segments exist. # ALTERNATE FILE=UPPER.ALT # # END OF FILE LEVEL SETTINGS! # # This marks the beginning of key segment level information. # If I were you, and I were creating BTB files, I would # place a large comment band between each key segment # to remind myself what I think I am doing. Just a # thought... # # The lines for each key segment are in the following order: # # START=n, where 'n' is the starting position of the key # LEN=n, where 'n' is the length of the key # MODIFIABLE=s, where 's' is Y or N (or YES or NO or Yes or...) # Allows Modifications to be made to the key? # DUPLICATES=s, ditto above...Allows Duplicate keys? # ALTERNATE=s, where 's' is as above. Alternate Collating Sequence? # DESCENDING=s, like above. Sorts Hi to Lo? # MANUAL=s, like above, Manual key? # TYPE=t, where 't' is EXACTLY one (case difference OK) of the following: # # "String", # "Integer", # "Float", # "Date", # "Time", # "Decimal", # "Money", # "Logical", # "Numeric", # "Bfloat", # "Lstring", # "Zstring", # "Unsigned Binary", # "Autoincrement", # # NULL=n, where 'n' is the decimal NULL value (commonly 0 or 32) OR # NULL=N/A to explicitly state no NULL value. # NULL= is OPTIONAL. # SEGMENT=s, where 's' is Y or N (or Yes or N0...). The number of # segments with a SEGMENT=No value MUST be one in this case # since only a single supplemental index can be declared # at once. # # Segment 1 # START=1 LEN=22 MODIFIABLE=n DUPLICATES=n ALTERNATE=n DESCENDING=n TYPE=STRING NULL=N/A SEGMENT=NO # # That's all, folks! #