ESQLVERSION

Sets OpenESQL syntax level.

Syntax:

Note: Micro Focus plans to deprecate ESQLVERSION in a future release.
ESQLVERSION={1.0 | 2.0 | 3.0}

Parameters

1.0
Sets no additional compiler directives or environment variables.
2.0
Sets the following compiler directive options:
  • AUTOCOMMIT
  • CURSORCASE

Sets the following environment variables:

  • SET CONCURRENCY=OPTCC
  • SET SCROLLOPTION=KEYSET
3.0
Sets the following environment variables:
  • SET CONCURRENCY=LOCKCC
  • SET SCROLLOPTION=DYNAMIC

Properties:

Default: ESQLVERSION=3.0

Scope:

Used at compile time: No
Behavior at run time: Process

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