Does teradata support the common trig functions

[ddhf]

I have looked in the online documentation and have not been able to locate anything.

 

[tdatgod]

Online documentation for All NCR products including CRM applications, The teradata database, and Cash registers/ATMs.

http://www.info.ncr.com

Specific to the Teradata data Warehousing offering

http://www.info.ncr.com/sd/sd-1.cfm

Specific to the Teradata Database

http://www.info.ncr.com/sd/sd-1.cfm?page=td

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.

 

[tdatgod]

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.