Java external stored procedures can use JDBC to establish a default connection to the database and directly execute SQL.
When an SQL statement within a Java external stored procedure accesses structured UDT, Period, or ARRAY type data, the values are returned based on the UDTTransformsOff, PeriodStructOn and ArrayTransformsOff flag set in the options parcel for the request.
This section provides highlights on using JDBC to execute SQL in Java external stored procedures, and identifies differences between accessing Vantage from a Java external stored procedure and accessing the database from a Java application. For details on using Teradata Driver for the JDBC Interface to access the database, see Teradata JDBC Driver Reference, available at https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html.