Lisa,

If you can post trigger code then i am sure some of us
can easily help you.


Thanks
Jignesh
--- [Email Address Removed] wrote:
>
> I have a table that has a datetime column that is
> used to give the
> timestamp of the last time that row was modified. I
> am trying to write an
> update trigger that will update that field to
> CURRENT TIMESTAMP every
> time that row is updated. I get error 0900 (general
> trigger error) no
> matter what I do. Can I get some guidance on how to
> implement this
> please.
>
> Thanks,
> Lisa Greetham
> Database Administrator, Corporate Internet Group
> Bank One
>
>
>
>
> This transmission may contain information that is
> privileged, confidential and/or exempt from
> disclosure under applicable law. If you are not the
> intended recipient, you are hereby notified that any
> disclosure, copying, distribution, or use of the
> information contained herein (including any reliance
> thereon) is STRICTLY PROHIBITED. If you received
> this transmission in error, please immediately
> contact the sender and destroy the material in its
> entirety, whether in electronic or hard copy format.
> Thank you.
>
>
>
---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> To unsubscribe, e-mail:
> db2udbdba-[Email Address Removed] For additional commands, e-mail:
> db2udbdba-[Email Address Removed]


=====
http://www.indiacause.org ***http://www.goodnewsindia.com

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
DB2 & UDB email list listserv db2-l LazyDBA home page