HINT |
The Hint clause is used to mention a browsing key on the For and Fillbox instructions.
SYNTAX 1
... Hint Key = key ...
SYNTAX 2
... With Nohint
|
Element |
Description |
Restrictions |
|
Key : |
Description of the key of a linked file for an SQL query under one of the following forms:
|
None |
|
id_clé |
variable_name that designates a key |
None |
|
expr_c |
Char type expression resulting in a string |
|
# Statement of a browsing key different from the sort key in read mode
# Read of all the orders of Customer DUPOND with these orders being sorted by their number.
# The SOH0 index is always used for the sort and the SOH1, index to browse the recordings
Local File SORDER[SOH]
For [SOH]SOH0 Hint Key SOH1
Where BPCORD=" DUPOND "
…
Next
End
# Statement of a browsing key different from the sort key in left list filling mode
Fillbox [BPC] GAU_CHE Hint Key =HINTLIS(0)
Hint key = is used associated with the For and Fillbox instructions in order to specify a browsing key.
Hint key = "" is used in association with the Fillbox instruction to indicate that the database must determine the browsing key.
With Nohint is used in association with the For instruction to indicate that the database must determine the browsing key.
By default, the For and Fillbox instructions leave it to the database to determine the browsing key, either in an Oracle or SQL Server database. As a consequence the keyword With Nohint is the default option of the For instruction, similarly, Hint key = "" is the default option of the Fillbox instruction.
|
Error |
Description |
|
|
|
|
Copyright © Sage 1999 - 2007 |