Re: Possible feature?

On Wednesday, 11. July 2001 17:28, you wrote:
> Mike Mascari writes:
> > MESSAGE ON INDEX i_employees IS
> > 'An employee with a matching Social Security number already exists';
> >
> > Then, when the UNIQUE constraint of the index is violated, instead of
> > the message:
> >
> > 'Cannot insert a duplicate key into a unique index i_test1'
> >
> > the client application would receive:
> >
> > 'An employee with a matching Social Security number already exists'
>
> I think what you're after is
>
> TRY
>   BEGIN
>     INSERT ...
>   END
> CATCH SQLCODE 12345 -- made up
>   BEGIN
>     RAISE 'your message here'
>   END
>
> I'm positive people would kill for that kind of feature.

Then we should use this syntax (like Oracle does):

BEGIN  INSERT ....

EXCEPTION WHEN .... THEN  RAISE 'your message here'
END


Regards, 
Klaus

-- 
Visit WWWdb at
http://wwwdb.org