Micro Focus Studio Enterprise Edition for Windows > Programming > Data Access > Database Access > Reference > OpenESQL > SQL Compiler Directive Options > BEHAVIOR

BEHAVIOR

Instructs OpenESQL to properly match your COBOL cursors with the database you specify, thus maximizing database cursor performance. BEHAVIOR makes use of multiple primitive directives and associates a default value for each primitive directive depending on the DBMS you are using. You can also override the default setting of any primitive directive.

Syntax:

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

Parameters:

ANSI	Enables OpenESQL to work like the ANSI standard, and enhances the access speed
MAINFRAME	Enables OpenESQL to work as it does on the mainframe, and enhances the access speed
UNOPTIMIZED	Provides backward compatibility with earlier Micro Focus products
CICS	Sets all of the following: Enables OpenESQL to work as it does on the mainframe Enhances the access speed Automatically sets the TRANSACTION primitive directive to GLOBAL
JCL	Sets all of the following: Enables OpenESQL to work as it does on the mainframe 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
`primitivedirective`	Optional directives that enable the fine-tuning of BEHAVIOR

Scope:

Used at compile time:	No
Behavior at run time:	Source file

See Scope - OpenESQL SQL Compiler Directive Options for more information.

Default:

BEHAVIOR=UNOPTIMIZED

Comments:

You can change the default setting to either ANSI or MAINFRAME using the OpenESQL Configuration Utility. However, when the BEHAVIOR directive is specified in program code, project settings, or in a compiler directive file, the specified parameter overrides the default setting.
Setting this directive can also affect the SQL types returned when using Dynamic SQL. See the DESCRIBE Statement topic for more information.
OpenESQL sets default values for primitive directives depending on the value of BEHAVIOR and your target database. See the topic Primitive Directives for more information.