Print and SPL Options - ODBC Driver for Teradata

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.