Examples - Teradata Vantage - Analytics Database

Example: PERIOD(DATE) Data Type

The following CREATE TABLE statement defines a PERIOD(DATE) column with a default value set using a Period literal.

CREATE TABLE t1
(
      employee_id         INTEGER,
      employee_name       CHARACTER(15),
      employee_duration   PERIOD(DATE)
      DEFAULT PERIOD '(2005-02-03, 2006-02-03)'
);

Example: Period Parameter in a Java UDF

REPLACE FUNCTION PDT_UDF (P1 PERIOD(DATE), P2 PERIOD(DATE))
RETURNS PERIOD (DATE)
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA 
EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.pdt_udf';

Result:

public static java.sql.Struct pdt_udf(java.sql.Struct p1, java.sql.Struct p2) throws SQLException

Alternatively, you can define the function as follows:

REPLACE FUNCTION PDT_UDF (P1 PERIOD(DATE), P2 PERIOD(DATE))
RETURNS PERIOD (DATE)
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA 
EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.pdt_udf(java.sql.Struct, java.sql.Struct) returns java.sql.Struct';

Result:

public static java.sql.Struct pdt_udf(java.sql.Struct p1, java.sql.Struct p2) throws SQLException

Example: Period Parameter in a Java External Stored Procedure

REPLACE PROCEDURE PDT_XSP(IN P1 PERIOD(DATE), INOUT P2 PERIOD(DATE), OUT P3 PERIOD(DATE))
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA 
EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.pdt_xsp';

Result:

public static void pdt_xsp(java.sql.Struct p1, java.sql.Struct[] p2, java.sql.Struct[] p3) throws SQLException