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