15.00 - Prerequisites - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)

Prerequisites

Before you can use these functions, you must run the Database Initialization Program (DIP) utility and run the DIPUDT script. The DIPALL and DIPUDT scripts create the calendar functions in the SYSLIB database. For more information about the DIP utility, see Utilities: Volume 1 (A-K).

If you have a user-developed UDF with the same name as a calendar function, you must remove that user-developed UDF from the normal UDF search path before you can invoke the calendar function. If the calendar function is not found in the current database, Teradata Database searches for the function in the SYSLIB database. Alternatively, you may invoke the calendar function by using the fully qualified syntax, SYSLIB.calendar_function_name.