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.
- Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems
- Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems