Access Query LanguageAQL modifierstape modifier

tape modifier

The tape modifier retrieves data from the currently attached tape, rather than the actual data level of the file. The tape must have been created in a t-dump format and must be positioned to the beginning of the appropriate tape file. The attribute-defining items specified in the AQL sentence are retrieved from the dictionary level of the specified file name.

Note: The tape modifier can be used only with AQL commands that do not sort prior to output, such as count, istat, list, list-label, reformat, select, stat, and sum.

Syntax

tape

Example(s)

This example assumes that the appropriate t-dump media has been attached and previously positioned at the proper tape file.

list invoices with date >= "1/1/04" and <= "12/31/04" tape

See also

list-device command, Modifiers, set-device command, t-att command, t-dump command, t-load command

Parent topic: AQL modifiers