Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Does teradata support the common trig functions
- Thread starter ddhf
- Start date
Online documentation for All NCR products including CRM applications, The teradata database, and Cash registers/ATMs.
Specific to the Teradata data Warehousing offering
Specific to the Teradata Database
Then select SQL REFERENCE.
Vol 2 is the Data Definition Language Reference Manual which includes the syntax for CREATE TRIGGER/REPLACE TRIGGER. page 8-22.
Do you have a specific question about triggers and/or the statements allowed in Triggers?
WE allow
Insert
Insert-select
Update
Delete
Abort/Rollback
Here is an example trigger.....
replace trigger testtrig
before DELETE on t1
referencing old_table as oldtab
for each statement
(del t2 where a1=oldtab.a;
);
this trigger deletes corresponding rows in another table t2 when someone deletes rows from the base table t1.
There is no reason the Triggered action has to be the same as the triggering action just the example I picked happens to be the same.
Specific to the Teradata data Warehousing offering
Specific to the Teradata Database
Then select SQL REFERENCE.
Vol 2 is the Data Definition Language Reference Manual which includes the syntax for CREATE TRIGGER/REPLACE TRIGGER. page 8-22.
Do you have a specific question about triggers and/or the statements allowed in Triggers?
WE allow
Insert
Insert-select
Update
Delete
Abort/Rollback
Here is an example trigger.....
replace trigger testtrig
before DELETE on t1
referencing old_table as oldtab
for each statement
(del t2 where a1=oldtab.a;
);
this trigger deletes corresponding rows in another table t2 when someone deletes rows from the base table t1.
There is no reason the Triggered action has to be the same as the triggering action just the example I picked happens to be the same.
Sorry Got too caught up in my own post.
TRIG not TRIGGERS. Math Functions.
Yes. WE added them the new version 4.1 released today. I was the Release Architect for 4.1.
Again the documentation links above apply and are up to date with the 4.1 documentation. You want volume 5 and make sure you select the v2r4.1 version.
We added...
Trigonometric function.
sin, cos, tan, asin, acos, atan, atan2.
Hyperbolic functions:
sinh, cosh, tanh, asinh, acosh, atanh.
Soundex.
Width_bucket.
and filled out the REGR functions.
COVAR_SAMP, REGR_R2, REGR_COUNT, REGR_AVGX,
REGR_AVGY, REGR_SXX, REGR_SYY, REGR_SXY,
We also added
PECENT_RANK to complement RANK which was added in v2r4.
Let me know if need anything else.
TRIG not TRIGGERS. Math Functions.
Yes. WE added them the new version 4.1 released today. I was the Release Architect for 4.1.
Again the documentation links above apply and are up to date with the 4.1 documentation. You want volume 5 and make sure you select the v2r4.1 version.
We added...
Trigonometric function.
sin, cos, tan, asin, acos, atan, atan2.
Hyperbolic functions:
sinh, cosh, tanh, asinh, acosh, atanh.
Soundex.
Width_bucket.
and filled out the REGR functions.
COVAR_SAMP, REGR_R2, REGR_COUNT, REGR_AVGX,
REGR_AVGY, REGR_SXX, REGR_SYY, REGR_SXY,
We also added
PECENT_RANK to complement RANK which was added in v2r4.
Let me know if need anything else.
- Status
Similar threads
- Locked
- Question