HP 3000 Manuals HP 3000 Manuals
Features of the Micro Focus Support
Most of the above-listed SQL systems are supplied with a precompiler that
takes as input a source program containing Embedded SQL and produces a
new source file containing only COBOL code. The Micro Focus support
offers the following advantages over these preprocessors:
* No separate preprocess stage
Compiling your SQL programs is performed in one step with little
or no difference from compiling non-SQL programs. This simplifies
the command line compilation process and provides the advantage of
other Micro Focus COBOL extensions which the precompilers might
not allow, such as: omission of the Identification Division, and
specification of copyfile search paths.
If you have the add-on products Workbench (for Windows and OS/2)
or Toolbox (for UNIX), this also removes the need to exit from
Workbench or Toolbox to precompile.
* Original SQL code shown in Animator
When you Animate a program after precompiling and compiling, you
are shown the modified source program. Using Micro Focus SQL
support, you are shown the original source code.
* No requirement for user coding API calls
Some of the SQL systems listed in the section Supported SQL
Systems, require coding calls directly to the database system in
order to enable connection to a database at execution time.
Micro Focus SQL support enables this connection to be made
automatically.
* Increased Data Protection
If the program terminates abnormally, the connection to the
database is closed normally in all possible cases. When this is
not done, it is possible to corrupt the database. For IBM
database engines, the database is rolled back to ensure integrity
of the data.
* Increased DB2 compatibility
* The INCLUDE statement is supported
* The DECLARE TABLE is supported
* The BEGIN DECLARE SECTION and END DECLARE SECTION can be
omitted
* DB2 style qualification of host variables is allowed in
embedded SQL statements
* Host variables need not be declared at the 01 level
* Group structures can be used
* The NOT operator is supported
* COMP data items can be used in place of COMP-5
NOTE Greater DB2 compatibility is provided by the add-on product Micro
Focus Host Compatibility Option, which works with and extends the
Micro Focus support documented here. Contact your Micro Focus
vendor for details.
* Increased ANSI compatibility
* The SQLCODE and SQLSTATE data items can be defined without
the requirement for the entire SQLCA data area.
These extensions to the SQL support are documented fully in the following
sections.