Logo Environmental XPRT
Companies
Products
Services
Software
Training
Applications
Sign in
List your business
ESI Services, LLC (ESI)
About
Downloads
  2. Companies
  3. ESI Services, LLC (ESI)
  4. Software
  5. COBOL-IT CitSQL Family - Oracle ...

COBOL-IT CitSQL Family - Oracle Database and IBM DB2 Database Software

SHARE

The CitSQL Family of products extends COBOL-IT’s commitment to embrace Open Source solutions. CitSQL provides Pre-compilers for the latest versions of Open Source Databases MySQL and PostgreSQL and with the Open Database Connectivity (ODBC) standard created by Microsoft. CitSQL provides different Runtime Components for the different databases, each of which is developed specifically for the target database. When debugging your code inside the Developer Studio, you may elect either to debug the original source code or the source code generated by the pre-compiler.

Our goal is to provide you with pre-compilers for MySQL, PostgreSQL and ODBC that you can integrate into your COBOL-IT Toolset, to further minimize your risks and costs. Oracle database and IBM DB2 database users are supported as well by using the database pre-compiler provided by their respective companies.

  • Run pre-compiler commands from a highly configurable resource file
  • Runtime components make native calls to the database
  • Intelligent handling of unrecognized SQL statements
  • Application of Standard Prefix
  • Supports multiple quoting conventions
  • Allocate extra memory for pre-compiling of very large source files
  • Log Mode to trace SQL operations for debugging purposes
  • Provide output in "free" source format
  • 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).
  • Integrated with the Developer Studio for purposes of pre-compiling and compiling and debugging.
  • 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.
  • Native calls to the database provide the highest level of performance.
  • 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.
  • 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.
  • Allows the user to use the same source code with different databases having different quoting conventions without changing the source code.
  • Effectively removes limitations caused by memory when handling very large source files.
  • Provides an effective debugging tool with a log file that contains a full record of SQL operations performed.
  • Allows user to match output format to the source format that they prefer and which matches the corporate coding conventions.
  • There is no need to statically link the runtime component to the program.
  • Provides users of CitSQL with all of the compiling, editing and debugging capabilities of the Developer Studio