Archives of the TeradataForum
Message Posted: Thu, 10 Mar 2005 @ 13:16:34 GMT
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 .
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.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|