Steps for Building an Application

The following steps apply to building all Embedded SQL applications:

1. Run the appropriate sqlprep precompiler to prepare your Embedded SQL program for compiling with a C compiler.

The sqlprep precompiler finds SQL statements, parses the SQL statements, and if applicable, creates an access plan or bind file. The precompiler creates a C program that can be compiled with an appropriate C compiler. For more information about sqlprep, see "Running the sqlprep Precompiler" later in this chapter.

If your program contains static SQL statements, depending on the options used, sqlprep creates an access plan, or a bind file, or neither. Access plans and bind files consist of a set of definitions for SQL Server stored procedures.

2. Compile the C program created by the precompiler by using an appropriate C compiler. The compiler creates object file(s).

3. Link the object file(s), the Embedded SQL library files, and any other needed library files to create an executable file for the desired environment.