Jump to content

Access query language

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Djm-leighpark (talk | contribs) at 14:07, 10 October 2021 (Further reading: Add one. In general Bourdon's later books would be better.). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Access, the successor to ENGLISH, is an English-like query language used in the Pick operating system.

The original name ENGLISH is something of a misnomer, as PICK's flexible dictionary structure meant that file and attribute names could be given aliases in any natural language. For instance the command SORT could be given the alias TRIEZ, the file CUSTOMER the alias CLIENT, the attribute BALANCE the alias BILAN and the particle BY the alias PAR. This would allow the database to be interrogated using the French-language command string "TRIEZ CLIENT PAR BILAN", resulting in a list of customers by balance.

Further reading

  • Bourdon, Roger J. (1984). "68000 and the Pick operating system". Microprocessors and Microsystems. 8 (7): 357–360. ISSN 0141-9331.
  • Gallant, Walter (1989). Pick access : a guide to the SMA/retrieval language. Sebastopol, CA: O'Reilly & Associates. ISBN 0-937175-41-2. OCLC 21506191.


This article is based on material taken from the Free On-line Dictionary of Computing prior to 1 November 2008 and incorporated under the "relicensing" terms of the GFDL, version 1.3 or later.