Prerequisites - Teradata Database

SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata® Database

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.