Teradata Preprocessor2 (SPP Prefix) Messages - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

Using Teradata Preprocessor2 (SPP Prefix) Messages

Preprocessor2 (PP2) is the Vantage precompiler and runtime SQL statement manager. Each diagnostic issued by the precompiler is associated with one of several severity levels. Each time preprocessing completes, the preprocessor terminates with a return code determined by the level of the most severe diagnostic that was issued. For more information, see Teradata Preprocessor2 for Embedded SQL Programmer Guide, B035-2446.

The PP2 messages start with SPP and a four digit number, followed by a description of the error or warning.

The severity level of the errors and their associated return codes are as follows:

  • Diagnostics returned by the preprocessor have identifying numbers of the form SPPnnnn, where nnnn is a four-digit number.
  • Most diagnostics displayed on the output listing consist of at least two lines. The first line always takes one of the following forms, depending on how precisely the diagnostic can be associated with a specific location in the input source program:
    • SPPnnnn <severity>
    • SPPnnnn <severity>, statement beginning on line <linenum>
    • SPPnnnn <severity> at line <linenum>, column <column>

The brackets (<>) are used to indicate information supplied by the precompiler when the diagnostic is issued.

Why Would I Use this Content?

Use this content to troubleshoot error conditions or to get additional information about the displayed message.

How Do I Use this Content?

Search for the message number to see the following information about the message:

  • An explanation about the message
  • Which compiler generated the message
  • Additional notes about the message
  • Possible remedies to the error condition

References to Other Relevant Content

  • For details of the SQLERRM field, see Teradata Preprocessor2 for Embedded SQL Programmer Guide, B035-2446.
  • For information on mapped CLI code to SQLSTATE and SQLCODE, see SQL Stored Procedures and Embedded SQL, B035-1148.
  • For information on DSNTIAR operation, see vendor documentation.