The client application languages that support embedded SQL are compiled languages. SQL is not defined for them. Therefore, you must precompile your embedded SQL code to translate the SQL to native code before you can compile the source using a native compiler.
The precompiler, Preprocessor2 (PP2), follows this procedure:
- Find the SQL code in the application source code.
- Isolate the code.
- Interpret the intent of the SQL code and translate it to Call-Level Interface (CLI) calls.
- Comment out the SQL code.
- Output native language source code with CLI calls substituted for the SQL source code.
You can compile the PP2 output with the native language compiler. For information about Call-Level Interface communications interface, see Client Communication with Vantage.