Re: NULLs in ecpg

wespvp@syntegra.com wrote:
> I couldn't find this in the archives...  In an ecpg program, given the
> statement (taken from the manual):
> 
> EXEC SQL INSERT INTO sometable VALUES (:v1, 'foo', :v2);

Indicators works as expected.  e.g.:

EXEC SQL INSERT INTO sometable         VALUES (:v1 :v1_ind, 'foo', :v2 :v2_ind);

> 
> Is there a way to create the record where ':v1' is NULL - as with indicators
> in a FETCH?  Or, do I have to generate different SQL statements in the C
> program?
> 
> Wes
> 

-- 
Edmund Bacon <ebacon@onesystem.com>