Syntax
Interactive QUEL syntax:
retrieve [[into] tablename] [unique]
(target_list) [where qual]
[sort [by] columnname [:sortorder] {, columnname [:sortorder]}]
[order [by] columnname [:sortorder] {,columnname[:sortorder]}]
[with with_clause]
The with clause is valid only when retrieving into a table. The with clause consists of the keyword with followed by a comma-separated list of one or more of the following options:
structure=storage structure name
key=(column list)
[no]journaling
[no]duplicates
location=locationame
fillfactor=1...100%
minpages=(>0)
maxpages=(>0)
nonleaffill=1...100%
leaffill/indexfill=1...100%
maxindexfill=ignored
allocation=(>0) (only for retrieve into)
extend=(>0) (only for retrieve into)
Embedded QUEL syntax, to retrieve into host variables:
## [repeat] retrieve [unique] (variable=result_expression
## {,variable = result_expression})
## [where qual] [sort [by] result_column {, result_column}]
## [{
## program code
## }]