Declaring and Specifying Indicator Variables

You declare indicator variables like host language variables in an SQL Declare section, and declare them as C numeric types. Indicator types can be long, short, sqldec, float, or double. For information on declaring host language variables, see the "Host Language Variables" section in this chapter.

Use this syntax to specify indicator variables in an ESQL statement wherever you can specify host language variables:

SYNTAX
:host-language-variable-ref [ [ INDICATOR ] :indicator-variable-ref ] 

A host language variable expression can optionally include an indicator variable. Do not separate corresponding host language and indicator variables with a comma. However, you do use a comma to separate one host language variable expression (including any indicator variable) from the next.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095