Processing Codes

The following Processing Codes are presented:

a (Algebraic) Processing Code

Creates algebraic formulas and relational operations consisting of operands and operators; these expressions are used by AQL as well as the B-tree indexes.

b (Bridge) 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.

c (Concatenate) Processing Code

Concatenates elements for output.

c (Controlling) Processing Code

Defines the controlling attribute in a controlling/dependent pair of attributes when placed in attribute 4 of the ADI.

call Processing Code

Calls a BASIC or FlashBASIC subroutine from the file-defining item or an ADI.

callc (Close Trigger) Processing Code

Called before a table is closed.

calld (Delete Trigger) Processing Code

Called before a file is deleted.

calle (Clear Trigger) Processing Code

Called before a file is cleared.

callo (Open Trigger) Processing Code

Called after a table has successfully been opened.

callr (Read Trigger) Processing Code

Called when a record is read from a table.

callx (Write Trigger) Processing Code

Called when a record is updated in a table.

cu (Character Update) 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.

d (Date) 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.

d (Dependent Value) Processing Code

Defines the dependent attribute in a control/dependent pair of correlated MultiValues; the controlling attribute must contain a c code.

f (f-correlative) Processing 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.

g (Group Extract) Processing Code

Extracts one or more groups of contiguous character substrings delimited by the specified character.

i (Index) Processing Code

Stored in the correlative (attribute 8) of the file-defining items to maintain index keys.

i (Local Index) Processing Code

Indicates that an index exists for the current attribute.

i (Remote Index) Processing Code

Used as an input-conversion (attribute 14) and indicates that this attribute is based on data indexed in another file.

id (Item ID) Processing Code

Used by the Update Processor to create new item-IDs.

if (if/then) Processing Code

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.

l (Length) Processing Code

Either restricts processing to values that fall within certain length restrictions or displays the length of a given value.

m (Mask) Processing Code

A masking conversion used for both numeric and text string formatting.

mc (Mask Character) Processing Code

Invokes one of many available processing codes available for special processing on numeric and alphabetic strings of characters.

mi (Must Input) Processing Code

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

mp (Mask Packed Decimal) Processing Code

Used for converting a value to a packed decimal value or a packed decimal value to a value.

ms (Mask Alter Sort) Processing Code

Alters the normal sort sequence of characters.

mt (Mask Time) 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.

mx (Mask ASCII to Hexadecimal) Processing Code

Converts all ASCII characters in a given value to their corresponding ASCII-hexadecimal equivalent.

my (Mask Hexadecimal to ASCII) Processing Code

Converts all ASCII hexadecimal characters in a given value to their corresponding ASCII equivalent.

o (Sort Values Ascending) Processing Code

Sorts the values in the specified attributes in ascending order.

p (Pattern Match) Processing Code

Tests a value and determines if it matches a predetermined pattern matchstring composed of alphabetic, numeric, or literal characters.

r (Range) Processing Code

Invokes the range function, and restricts processing to those values that fall within given minimum and maximum range restrictions.

s (Subindex) Processing Code

Used to update an index that uses a file translation if the value in the translate file changes.

s (Substitution) Processing Code

Substitutes either a data value from the referenced attribute or literal text when the current data value is null or zero.

t (Text Extraction) Processing Code

Provides a facility for extracting any number of characters from an attribute, starting at the position and length specified.

t (Translate) 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.

u (User Exit) Processing Code

AQL user exits allow direct access to system functions.

v (Value Limit) Processing Code

Specifies the maximum number of values allowed in an attribute when as an input-conversion (attribute 14).

v (Within) Processing Code

Used by the within connective and must be placed in the correlative attribute 8 of the file-defining item (D-pointer).

x (Display Only) Processing Code

Used as an input-conversion (attribute 14) and indicates that the specified attribute is for display only.

x (Update Stamp) Processing Code

Placed in the correlative of a file-defining item to provide an audit trail for items that are updated via the Update Processor.

xc (Center) Processing Code

Centers the input string in a field of spaces.

xi (Input Conversion) Processing Code

Forces any further conversions to be treated as if they were an input-conversion.

xo (Input Conversion) Processing Code

Forces any further conversions to be treated as output-conversions.

xr (Running Subtotal) Processing Code

Produces a running subtotal of an output column on an AQL listing or report.

xt (Toggle Input/Output Conversion) Processing Code

Toggles the conversion direction from an input to an output-conversion or vice-versa.

y (Update Stamping) Processing Code

Stamps user, PIB, and/or time/date update information into an internal item header from all processors.

za (Assembly Code Format) Processing Code

Displays a D3 item in a format compatible with assembly source code.

zc (Zip Code) Processing Code

Uses the zcf file to display the city, state, and Zip code.