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.
- 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