Progress
Embedded SQL-92
Guide and Reference


Use the NULL Keyword

You can use the NULL keyword in the value list to indicate that a column in the column list should be assigned a NULL value.

EXAMPLE

The following example shows how to insert NULL values for the commission and projno columns using the NULL keyword:

EXEC SQL
     INSERT INTO employee
     VALUES (8585, ’RALPH’, ’CLERK’, ’02/02/1999’,
     2000, NULL, 10, NULL) ; 


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