Re: Update a table in another schema through a trigger

In article <7sse1k$bvi$1_at_news.uk.ibm.com>, Birte Midjaas <birte.midjaas_at_no.ibm.com> writes
>Hello!
>I would like to update a table in another schema in the same database. This
>should be done through a trigger on Insert or Update. How do I address the
>table in the other schema?
>
>Thanks for your help and advices.
>

update schema.table

   set wibble = 'X'

Andy
--
Andy Hardy. PGP key available on request