| Run pre-compiler commands from a highly configurable resource file |
Resource files support wildcard syntax that allows for short-hand designation of name and location of source files and can be used to apply multiple options to multiple files. |
| Runtime components make native calls to the database |
Native calls to the database provide the highest level of performance. |
| Intelligent handling of unrecognized SQL statements |
Different databases can support their own extensions to deal with table spaces, indexing methods, special column types and more. CitSQL will pass along SQL statements directly to the database that it does not recognize. This greatly expands the ability of the pre-processor to work across multiple databases. |
| Application of Standard Prefix |
CitSQL allows the user to avoid collisions between generated variables and pre-existing variables with the application of a prefix to the generated variables. This eliminates the need to resolve conflicts which can be time-consuming. |
| Supports multiple quoting conventions |
Allows the user to use the same source code with different databases having different quoting conventions without changing the source code. |
| Allocate extra memory for pre-compiling of very large source files |
Effectively removes limitations caused by memory when handling very large source files. |
| Log Mode to trace SQL operations for debugging purposes |
Provides an effective debugging tool with a log file that contains a full record of SQL operations performed. |
| Provide output in "free" source format |
Allows user to match output format to the source format that they prefer and which matches the corporate coding conventions. |
| The pre-compiled source code produced by CitSQL produces calls to the runtime component which is included with the product as either a (Windows) DLL or shared object ( Linux/UNIX). |
There is no need to statically link the runtime component to the program. |
| Integrated with the Developer Studio for purposes of pre-compiling and compiling and debugging. |
Provides users of CitSQL with all of the compiling, editing and debugging capabilities of the Developer Studio |