Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 13:16:34 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Trigger deployment

From:		Victor Sokovin

I m working on teradata 6.2 version and I want to deploy trigger in teradata same as in oracle which I have deployed. and my trigger contains variable declaration and also logical condition like If,Else

so is teradata supports variable declaration and also logical condition like If,Else?

6.2? I was not aware it was available.

It might be worth consulting the manual before plunging into the conversion of Oracle triggers because you will find that the triggers are implemented differently in Teradata.

The latest manual I have is called "SQL Reference Data Definition Statements". It was released in November 2004 and the version of TD was 6.0 back then. The document ID is B035-1144-064A. You should be able to download it from www.info.ncr.com .

can I call procedure from trigger?

Yes.

can I call macro contain select..into clause or logical condition ?

INSERT=E2=80=A6 SELECT is allowed but I find the following:

"The following points about some triggered action statements are important:

     IF INSERT=E2=80=A6 SELECT is specified =E2=80=A6 THEN =E2=80=A6

direct references by this statement to the triggering table are treated as outer references." (I have edited the paragraph to get rid of the original layout).

This is just one example of the "Yes, but ..." remarks you will find in the manual. I don't think it makes sense to reproduce them all here.

should I need to use other version of teradata?

Well, if you have a choice, perhaps you might prefer an earlier version as triggers have changed a lot in release 6 compared to the previous releases. Who knows, you might find the "old" triggers more convenient for your purpose but then again what will you do when the database is upgraded?

You should also be able to find quite a few threads on triggers in the archives of this forum. Just use the Google search on the forum's web site.

Regards,

Victor


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference