15.10 - Print and SPL Options - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

Stored procedures can specify two storing options relating to the creation-time attributes:

  • Whether to save SPL PRINT statements in the compiled procedure
  • Whether to store the SPL source text in Teradata Database
  • Print Option

    The possible values are P and N. The value P indicates that the SPL PRINT statements specified in the stored procedure body will be saved in the compiled stored procedure. The value N, which is the default, indicates that the SPL PRINT statements are not to be saved. Rather, they are preserved in the SPL source text if the SPL source text is stored in Teradata Database (ProcedureWithSPLSource = Y).

    ProcedureWithSPLSource

    The possible values are Y and N. The value Y is the default. It indicates that the SPL source text needs to be stored in Teradata Database. The value N indicates that the SPL source text should not be stored in the server.

    These are options that can be set in ODBC DSN.