Progress
Embedded SQL-92
Guide and Reference
Using Indicator Variables
Indicator variables can be used with input host variables and output host variables. A NULL value can be inserted when an indicator variable is used along with the input host variable, if the indicator variable is set to -1. In the output variables, indicator variables are used to check for NULL values and other error conditions.
When you issue a query, use an indicator variable to check for NULL values on associated columns.
Table 12–1 lists the indicator variable values and their meanings.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |