15.10 - OPTIONS, SOURCE, and XREF Sections - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K
 

Table 3: OPTIONS, SOURCE, and XREF Section Information

Section

Contents of Section

Option that Controls Output or Suppression of the Section

Other Information

OPTIONS

  • PP2 options that have been specified at invocation
  • options used by PP2
  • option errors detected by PP2
  • OPTIONS/NOOPTIONS

    This section does not contain specified userid.

    SOURCE

  • the same source that is input to PP2. The section format depends on the host language and includes line numbers known to PP2 and any included lines brought in using EXEC SQL INCLUDE statements.
  • source errors detected by PP2
  • SOURCE/NOSOURCE

    -

    XREF

  • host variable, cursor, and dynamic statement declarations and usages
  • summary of input/output records
  • summary of the warnings and errors detected by PP2
  • XREF/NOXREF

    Asterisks in the variable declaration type field indicate that the size of the field exceeds the capability of the cross reference. However, this variable remains valid for use in SQL requests.