On 7/16/04 11:11 AM, "Edmund Bacon" <ebacon(at)onesystem(dot)com> wrote:
> Indicators works as expected. e.g.:
>
> EXEC SQL INSERT INTO sometable
> VALUES (:v1 :v1_ind, 'foo', :v2 :v2_ind);
Hmm. I tried that. Just tried it again and it worked. Must have had a
typo before. Sorry.
What about if I have something like:
... VALUES (TO_TIMESTAMP(:expirationDate, 'YYYYMMDDHH24MISS'), 'foo', :v2)
How can I insert NULLS for expirationDate when there's a function in the
way? Using
... VALUES (TO_TIMESTAMP(:expirationDate, 'YYYYMMDDHH24MISS') :ind1, ...
won't work.
Wes