BEHAVIOR

Instructs OpenESQL to properly match your COBOL cursors with the database you are using, thus maximizing database cursor performance. BEHAVIOR makes use of multiple primitive directives and associates a default value for each primitive directive depending on the target DBMS. You can also override the default setting of any primitive directive.
Note:
  • If you don't specify any BEHAVIOR primitive directives, and you also accept the default primitive directive values listed in the relevant table in the Default Primitive Directives section later in this topic, the TARGETDB directive is not required; however, you must specify TARGETDB if you want to use different default values for any primitive directive.
  • Setting the BEHAVIOR directive can also affect the SQL types returned when using Dynamic SQL. See the DESCRIBE Statement topic for more information.
  • Because the ADO.NET API does not support prefetching, very limited support is provided for BEHAVIOR primitive directives with DBMAN=ADO. See DBMAN Directive Settings for more information.

Syntax:

BEHAVIOR={OPTIMIZED | UNOPTIMIZED | ANSI | MAINFRAME | CICS | JCL} [primitivedirective [value]]...

Parameters:

OPTIMIZED Enables OpenESQL to optimize ambiguous cursor declarations; enhances the access speed
UNOPTIMIZED Provides backward compatibility with earlier Micro Focus products, where ambiguous cursors are both updateable and scrollable
ANSI Enables OpenESQL to work like the ANSI standard; enhances the access speed
MAINFRAME Synonym for OPTIMIZED
CICS Sets all of the following:
  • Enables OpenESQL to work as it does on the mainframe, optimizing ambiguous cursor declarations
  • Enhances the access speed
  • Automatically sets the TRANSACTION directive to GLOBAL
JCL Sets all of the following:
  • Enables OpenESQL to work as it does on the mainframe, optimizing ambiguous cursor declarations
  • Enhances the access speed
  • Checks for the following statements that are not compatible with JCL applications:
    • CONNECT
    • DISCONNECT
    • SET CONNECT
  • Reports an error for each incompatible statement found
  • Automatically sets the TRANSACTION directive to LOCAL
primitivedirective Optional directives that enable the fine-tuning of BEHAVIOR

Properties:

Default: BEHAVIOR=OPTIMIZED

Scope:

Used at compile time: Yes