Processing codes commands

The a processing code is a recursive algebraic function that creates algebraic formulas and relational operations consisting of operands and operators; these expressions are used by AQL as well as the B-tree indexes. The a processing codes are translated into f processing codes by the AQL compiler. The functional operators and operands for the a processing code are the same as that of the f processing code, except as noted.

The b processing code maintains a horizontal relationship (bridge) between an attribute in one item and an item in another file (or the same file) on the system level.

The c processing code concatenates elements for output.

The c processing code defines the controlling attribute in a controlling/dependent pair of attributes when placed in attribute 4 of the ADI.

The call processing code calls a BASIC or FlashBASIC subroutine from the file-defining item or an ADI. Called subroutines are Flash compiled to improve performance.

The callc (close trigger) is called before the table is closed.

The calld (delete file trigger) is called before the file is deleted.

The calle (clear file trigger) is called before the file is cleared.

For Windows (FSI): The callo (open trigger) is called after a table has successfully been opened.

The callr (read trigger) is called when a record is read from the table.

The callx processing code is called when a record is updated in the table.

The cu processing code allows data in a defined attribute with an output-conversion (attribute 7) or correlative (attribute 8) to be changed character by character with the Update processor. The cu processing code is placed in the input-conversion (attribute 14). If cu is not specified, existing data is erased and nulled when editing is started.

The d processing code invokes the date conversion function to convert an external date to internal format, or more commonly, to convert an internal date to one of many available output formats.

The d processing code defines the dependent attribute in a control/dependent pair of correlated MultiValues; the controlling attribute must contain a c code. The attribute count specified in the attribute count parameter must contain the c code and attribute count of the controlling attribute. Note that this function belongs in attribute 4 of the item.

The encrypt processing code is field-level encryption functionality that works with the encrypt-file and decrypt-file commands.

The f-correlative is used in the conversion (attribute 7), correlative (attribute 8), and input-conversion (attribute 14) attributes of attribute-defining items to create and modify the associated attribute value using various mathematical and logical operations.

The g processing code extracts one or more groups of contiguous character substrings delimited by the specified character.

The i processing code is stored in the correlative (attribute 8) of the file-defining items to maintain index keys. The root FID (VME only) is inserted by the system and must not be altered.

The i processing code indicates that an index exists for the current attribute. It must be defined in the attribute-defining item that corresponds to a local B-tree index previously created with a create-index command.

The i processing code is used as an input-conversion (attribute 14) and indicates that this attribute is based on data indexed in another file. When editing data in this attribute, the user can cruise both forward and backward through the index in the specified secondary file.

The id processing code is used by the Update processor to create new item-IDs. Originally implemented for the Update Processor, it was later implemented for all write operations within the D3 Windows FSI to facilitate transaction enqueuing for FSI Hot Backup.

The if processing code is used in dictionary attributes 7 and 8 (conversion and correlative) to generate values based on results of evaluation of expression according to the rules of a-correlative construction.

The l processing code either restricts processing to values that fall within certain length restrictions or displays the length of a given value.

The m processing code is a masking conversion used for both numeric and text string formatting. This conversion is quite complex because nearly all of the elements available in its syntax are optional. The elements are listed in the order that the system evaluates the expression. If an element is going to be used, it must be in the same order shown. Each of the elements available is discussed.

The mc processing code invokes one of many available processing codes available for special processing on numeric and alphabetic strings of characters. Multiple mc conversions may be placed on the same attribute in an attribute-defining item, provided that each is delimited by a value mark.

The mi processing code is used as an input-conversion code (attribute 14) and prohibits filing an item if any attribute defined with an mi code is null.

The mp processing code is used for converting a value to a packed decimal value or a packed decimal value to a value.

The ms processing code alters the normal sort sequence of characters.

The mt processing code invokes the time conversion function to convert external time representations to internal format or to convert internal time values to one of a variety of external time formats.

The mx processing code converts all ASCII characters in a given value to their corresponding ASCII-hexadecimal equivalent. The characters are converted one at a time to 2-digit hexadecimal numbers. The my code is the inverse of the mx code.

The my processing code converts all ASCII hexadecimal characters in a given value to their corresponding ASCII equivalent. The characters are converted two at a time to 1-digit ASCII characters. The mx code is the inverse of the my code.

The o processing code sorts the values in the specified attributes in ascending order. The values are sorted when the item is filed.

The p processing code tests a value and determines if it matches a predetermined pattern matchstring composed of alphabetic, numeric, or literal characters.

The r processing code invokes the range function, and restricts processing to those values that fall within given minimum and maximum range restrictions. Multiple range specifications allow display of the data value if the data value falls between any of the range pair sets. In using multiple range set specifications on negative values, the ranges should be in ascending sequence, beginning with the lowest.

The s (Subindex) processing code is used to update an index that uses a file translation if the value in the translate file changes. This processing code is set from Attribute 8 of the File Definition Item for the data section of a translate file.

The s processing code substitutes either a data value from the referenced attribute or literal text when the current data value is null or zero.

The t processing code provides a facility for extracting any number of characters from an attribute, starting at the position and length specified.

The t processing code uses the presented value as an item-ID and attempts to retrieve the corresponding item in another file to obtain a value from one of its attributes to substitute.

AQL user exits allow direct access to system functions.

The v processing code specifies the maximum number of values allowed in an attribute when as an input-conversion (attribute 14). If the v processing code is not defined, there is no limit to the number of values available in an attribute.

The v processing code is used by the within connective and must be placed in the correlative attribute 8 of the file-defining item (D-pointer).

The x processing code is used as an input-conversion (attribute 14) and indicates that the specified attribute is for display only. The attribute cannot be updated.

The x processing code is placed in the correlative of a file-defining item to provide an audit trail for items that are updated via the Update processor.

The xc processing code centers the input string in a field of spaces.

The xi processing code forces any further conversions to be treated as input-conversions.

The xo processing code forces any further conversions to be treated as output-conversions.

The xr processing code produces a running subtotal of an output column on an AQL listing or report.

The xt processing code toggles the conversion direction from an input to an output-conversion or vice-versa.

The y processing code stamps user, PIB, and/or time/date update information into an internal item header from all processors.

The za processing code displays a D3 item in a format compatible with assembly source code.

The zc processing code uses the zcf file to display the city, state, and Zip code. For international zip codes, an additional country file is used. For U.S.A. zip codes, zc displays a standard 5-digit zip code or the zip+4 code.