16.10 - Client-Server Applications Connectivity - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

Applications performing embedded SQL statements need to preprocessed by the Teradata Preprocessor2, which runs on a client system.

You can run the preprocessor against an application without connecting to Teradata Database if you specify the SQLCHECK (-sc) option as NOSYNTAX. However, to precompile and run an application, a separate connection to Teradata Database is required for the precompilation and the runtime event.

For instructions on how to prepare, precompile, and run an application on Teradata Database with embedded SQL statements, see SQL Stored Procedures and Embedded SQL and Teradata Preprocessor2 for Embedded SQL Programmer Guide.

Also see:

  • Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems
  • Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems