Create Trigger examples?

[CapsuleCorpJX]

I cant seem to find any create trigger examples.

Basically for each row that gets updated, i want to see what user is making the change, and depending on the username, I want to set a column for that row.

Can anyone point me in a good direction?

 

[tdatgod]

Hi,
We don't have recursive Triggers. WEll maybe in 6.x now I forget. The best you can do is create a LOG TABLE to record who is making the change.

Why not simply use the Variable

user

when inserting the row?


update blort
set myuser = user,
field = 7;

or something like that.

 

[CapsuleCorpJX]

NvM, I found a really good manual:

http://www.teradata.com/t/pdf.aspx?a=83673&b=125778