6. QUEL and EQUEL Statements : Retrieve Statement—Retrieve Table Rows : Syntax
 
Share this page                  
Syntax
Interactive QUEL syntax:
retrieve [[intotablename] [unique
(target_list) [where qual]
[sort [bycolumnname [:sortorder] {, columnname [:sortorder]}]
[order [bycolumnname [: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 [byresult_column {, result_column}] 
## [{
##   program code
## }]