The following Processing Codes are presented:
Creates algebraic formulas and relational operations consisting of operands and operators; these expressions are used by AQL as well as the B-tree indexes. |
|
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. |
|
Concatenates elements for output. |
|
Defines the controlling attribute in a controlling/dependent pair of attributes when placed in attribute 4 of the ADI. |
|
Calls a BASIC or FlashBASIC subroutine from the file-defining item or an ADI. |
|
Called before a table is closed. |
|
Called before a file is deleted. |
|
Called before a file is cleared. |
|
Called after a table has successfully been opened. |
|
Called when a record is read from a table. |
|
Called when a record is updated in a table. |
|
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. |
|
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. |
|
Defines the dependent attribute in a control/dependent pair of correlated MultiValues; the controlling attribute must contain a c code. |
|
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. |
|
Extracts one or more groups of contiguous character substrings delimited by the specified character. |
|
Stored in the correlative (attribute 8) of the file-defining items to maintain index keys. |
|
Indicates that an index exists for the current attribute. |
|
Used as an input-conversion (attribute 14) and indicates that this attribute is based on data indexed in another file. |
|
Used by the Update Processor to create new item-IDs. |
|
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. |
|
Either restricts processing to values that fall within certain length restrictions or displays the length of a given value. |
|
A masking conversion used for both numeric and text string formatting. |
|
Invokes one of many available processing codes available for special processing on numeric and alphabetic strings of characters. |
|
Used as an input-conversion code (attribute 14) and prohibits filing an item if any attribute defined with an mi code is null. |
|
Used for converting a value to a packed decimal value or a packed decimal value to a value. |
|
Alters the normal sort sequence of characters. |
|
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. |
|
Converts all ASCII characters in a given value to their corresponding ASCII-hexadecimal equivalent. |
|
Converts all ASCII hexadecimal characters in a given value to their corresponding ASCII equivalent. |
|
Sorts the values in the specified attributes in ascending order. |
|
Tests a value and determines if it matches a predetermined pattern matchstring composed of alphabetic, numeric, or literal characters. |
|
Invokes the range function, and restricts processing to those values that fall within given minimum and maximum range restrictions. |
|
Used to update an index that uses a file translation if the value in the translate file changes. |
|
Substitutes either a data value from the referenced attribute or literal text when the current data value is null or zero. |
|
Provides a facility for extracting any number of characters from an attribute, starting at the position and length specified. |
|
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. |
|
Specifies the maximum number of values allowed in an attribute when as an input-conversion (attribute 14). |
|
Used by the within connective and must be placed in the correlative attribute 8 of the file-defining item (D-pointer). |
|
Used as an input-conversion (attribute 14) and indicates that the specified attribute is for display only. |
|
Placed in the correlative of a file-defining item to provide an audit trail for items that are updated via the Update Processor. |
|
Centers the input string in a field of spaces. |
|
Forces any further conversions to be treated as if they were an input-conversion. |
|
Forces any further conversions to be treated as output-conversions. |
|
Produces a running subtotal of an output column on an AQL listing or report. |
|
Toggles the conversion direction from an input to an output-conversion or vice-versa. |
|
Stamps user, PIB, and/or time/date update information into an internal item header from all processors. |
|
Displays a D3 item in a format compatible with assembly source code. |
|
Uses the zcf file to display the city, state, and Zip code. |