HINT

Contents


The Hint clause is used to mention a browsing key on the For and Fillbox instructions. 

Syntax

   SYNTAX 1
   ... Hint Key = key ...

   SYNTAX 2 
   ... With Nohint

Parameters

Element

Description

Restrictions

  Key :

Description of the key of a linked file for an SQL query under one of the following forms:

  • id_clé
  • '=' expr_c

None

id_clé

variable_name that designates a key

None

expr_c

Char type expression resulting in a string

Examples

   # 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)

Description and comments

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.

New to version 140

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.

Associated errors

Error

Description

 

 

Associated keywords

For - Fillbox


CONTENTS

Copyright © Sage 1999 - 2007