Progress
Embedded SQL-92
Guide and Reference


Using Indicator Variables

After a query, you can identify NULL values by examining the indicator variables associated with the target output host variables.

EXAMPLE

The following example shows how to identify NULL values after retrieving a row:

EXEC SQL
     SELECT ename, job, deptno, projno
     INTO :ename_v, :job_v, :deptno_v, :projno_v:projno_i
     FROM employee
     WHERE empno = 1250 ;
if (projno_i == -1)
     printf ("project number is NULL\n") ; 


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