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.