iqsqlpp SQL Preprocessor Utility

The Sybase IQ SQL preprocessor utility iqsqlpp translates the SQL statements in an input file (.sqc) into C language source that is put into an output file (.c).

Embedded SQL is a database programming interface for the C and C++ programming languages. Embedded SQL consists of SQL statements intermixed with (embedded in) C or C++ source code. These SQL statements are translated by an SQL preprocessor into C or C++ source code, which you then compile.

Syntax

iqsqlpp [ options ] <in filename > [<out filename> ]

Parameters

This table lists the options available for the iqsqlpp utility.

iqsqlpp options
Option	Description
-d	Favor data size.
-e `<level>`	Flag nonconforming SQL syntax as an error. The allowed values of <level> are: c03– Flag syntax that is not core SQL/2003 syntax p03 – Flag syntax that is not full SQL/2003 syntax c99 – Flag syntax that is not core SQL/1999 syntax p99 – Flag syntax that is not full SQL/1999 syntax e92 – Flag syntax that is not entry-level SQL/1992 syntax i92 – Flag syntax that is not intermediate-level SQL/1992 syntax f92 – Flag syntax that is not full-SQL/1992 syntax t – Flag syntax that is not full-SQL/1992 syntax u – Flag non-standard host variable types The following are also supported for compatibility with previous versions: e (for entry-level SQL92), i, (for intermediate-level SQL92), f (for full SQL92), and w (to allow all supported syntax).
-h `<width>`	Limit the maximum line length of output.
-k	Include user declaration of SQLCODE.
-n	Line numbers.
-o `<O/S spec>`	Target operating system specification (WINDOWS, WINNT or UNIX).
-q	Quiet mode—do not print banner.
-r-	Generate reentrant code.
-s `<len>`	Maximum string constant length for the compiler.
-w <level>	Flag nonconforming SQL syntax as a warning. The allowed values of <level> are: c03– Flag syntax that is not core SQL/2003 syntax p03 – Flag syntax that is not full SQL/2003 syntax c99 – Flag syntax that is not core SQL/1999 syntax p99 – Flag syntax that is not full SQL/1999 syntax e92 – Flag syntax that is not entry-level SQL/1992 syntax i92 – Flag syntax that is not intermediate-level SQL/1992 syntax f92 – Flag syntax that is not full-SQL/1992 syntax t – Flag syntax that is not full-SQL/1992 syntax u – Flag non-standard host variable types
-x	Change multibyte SQL strings to escape sequences.
-z `<cs>`	Specify the collation sequence. For a list of recommended collation sequences, enter iqinit -l at a command prompt.

Usage

The SQL preprocessor processes a C or C++ program containing Embedded SQL before the compiler is run. iqsqlpp translates the SQL statements in the input file sql-filename into C language source that is put into the output-filename. The normal extension for source programs with Embedded SQL is .sqc. The default output file name is the sql-filename with an extension of .c. If the sql-filename has a .c extension, the default output file name extension is .CC.

Options

-d – Favor data size. Generate code that reduces data space size. Data structures are reused and initialized at execution time before use. This increases code size.
e <flag>- – This option flags, as an error, any Embedded SQL that is not part of a specified set of SQL92.
The allowed values of <flag> and their meanings are as follows:
- e – Flag syntax that is not entry-level SQL92 syntax.
- i – Flag syntax that is not intermediate-level SQL92 syntax.
- f – Flag syntax that is not full-SQL92 syntax.
- t – Flag non-standard host variable types.
- w – Allow all supported syntax.
- u – Flag syntax that is not supported by UltraLite.
- c99 – Flag syntax that is not core SQL/1999 syntax.
- c03 – Flag syntax that is not core SQL/2003 syntax.
- p99 – Flag syntax that is not full SQL/1999 syntax.
- p03 – Flag syntax that is not full SQL/2003 syntax.

-h width – Limits the maximum length of lines output by iqsqlpp to width. The continuation character is a backslash (\), and the minimum value of width is ten.

-k – Notifies the preprocessor that the program to be compiled includes a user declaration of SQLCODE.

-n – Generate line number information in the C file. This consists of #line directives in the appropriate places in the generated C code. If the compiler you are using supports the #line directive, this option makes the compiler report errors on line numbers in the SQC file (the file with the Embedded SQL) as opposed to reporting errors on line numbers in the C file generated by the SQL preprocessor. Also, the #line directives are used indirectly by the source level debugger so that you can debug while viewing the SQC source file.

-o – <O/S spec> Specify the target operating system. This option must match the operating system where you run the program. A reference to a special symbol is generated in your program. This symbol is defined in the interface library. If you use the wrong operating system specification or the wrong library, an error is detected by the linker. The supported operating systems are:
- WINDOWS – Microsoft Windows
- UNIX – Use this option if you are creating a 32-bit UNIX application.
- UNIX64 – Use this option if you are creating a 64-bit UNIX application.

-q – Operate quietly. Do not print the banner.

-r- – Generate reentrant code. For more information on reentrant code, see SQL Anywhere Server - Programming > SQL Anywhere Data Access APIs > SQL Anywhere embedded SQL > The SQL Communication Area (SQLCA) > SQLCA management for multi-threaded or reentrant code.
Note: This reference points to SQL Anywhere documentation.

-s <len> – Set the maximum size string that the preprocessor puts into the C file. Strings longer than this value are initialized using a list of characters (“a,” “b,” “c,” and so on). Most C compilers have a limit on the size of string literal they can handle. This option is used to set that upper limit. The default value is 500.

-w <flag> – This option flags any Embedded SQL that is not part of a specified set of SQL92 as a warning.
The allowed values of <flag> and their meanings are as follows:
- e – Flag syntax that is not entry-level SQL92 syntax.
- i – Flag syntax that is not intermediate-level SQL92 syntax.
- f – Flag syntax that is not full-SQL92 syntax.
- t – Flag non-standard host variable types.
- u – Flag syntax that is not supported by UltraLite.
- w – Allow all supported syntax.
- c03 – Flag syntax that is not core SQL/2003 syntax.
- c99 – Flag syntax that is not core SQL/1999 syntax.
- p99 – Flag syntax that is not full SQL/1999 syntax.
- p03 – Flag syntax that is not full SQL/2003 syntax.

-x – Change multibyte strings to escape sequences so that they can pass through compilers.

-z <cs> – This option specifies the collation sequence. For a list of recommended collation sequences, enter iqinit -l at a command prompt.
The collation sequence helps the preprocessor understand the characters used in the source code of the program, for example, in identifying alphabetic characters suitable for use in identifiers. If you do not specify -z, the preprocessor attempts to determine a reasonable collation to use, based on the operating system and the IQLANG and IQCHARSET environment variables.