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.




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