The client application languages that support embedded SQL are all compiled languages. SQL is not defined for any of them. For this reason, you must precompile your embedded SQL code to translate the SQL into native code before you can compile the source using a native compiler.
The precompiler tool is called Preprocessor2 (PP2), and you use it to:
The output of the precompiler is native language source code with CLI calls substituted for the SQL source. After the precompiler generates the output, you can process the converted source code with the native language compiler. For information about Call‑Level Interface communications interface, see Chapter 6: “Client Communication with Teradata Database.”