Using Indicator Variables to Set NULL Values

In this example, the indicator variable, costind, is set to -1 before the SQL statement executes. When the UPDATE statement executes, it sets the price column in any rows that satisfy the search condition to the NULL value:

costind = -1;

EXEC SQL UPDATE item SET price = :costvar INDICATOR :costind
         WHERE item\-num > 1000; 


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