17.00 - 17.05 - Client-Server Applications Connectivity - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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 Vantage if you specify the SQLCHECK (-sc) option as NOSYNTAX. However, to precompile and run an application, a separate connection to Vantage is required for the precompilation and the runtime event.

For instructions on how to prepare, precompile, and run an application on Vantage with embedded SQL statements, see Teradata Vantage™ - SQL Stored Procedures and Embedded SQL , B035-1148 and Teradata® Preprocessor2 for Embedded SQL Programmer Guide, B035-2446.

Also see:
  • Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418
  • Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems, B035-2417