470,587 Members | 2,200 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,587 developers. It's quick & easy.

coalesce?

Hi,

I m trying to use coalesce but i m getting this error below, btw i m using db2 8.2.
what i m doing is;
...
where eh.toblm = coalesce(NULL,eh.toblm)

SQL0206N "NULL " is not valid in the context where it is used.

Actually what i want to do is, get the result of this select statement either @id is NOT NULL or NULL! if @id is NULL then all results should be displayed!
...
where eh.toblm = coalesce(@id,eh.toblm)
Jan 21 '07 #1
0 1313

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Bob Bedford | last post: by
2 posts views Thread by Jeff Roughgarden | last post: by
3 posts views Thread by Steffen Vulpius | last post: by
5 posts views Thread by John Greve | last post: by
10 posts views Thread by db2group88 | last post: by
2 posts views Thread by raysefo | last post: by
1 post views Thread by =?Utf-8?B?R1ROMTcwNzc3?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.