ALLOWSERVERSELECT

Passes unrecognized EXEC SQL SELECT statements through to the server, thus enabling server-specific behavior.

Syntax:

[NO]ALLOWSERVERSELECT

Properties:

Default: NOALLOWSERVERSELECT

Scope:

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

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

Comments:

NOALLOWSERVERSELECT gives an error when OpenESQL does not recognize an EXEC SQL SELECT statement.

NOALLOWSERVERSELECT behavior is compatible with versions of Enterprise Developer earlier than 5.0.

When ALLOWSERVERSELECT is set, OpenESQL simply passes unrecognized EXEC SQL SELECT statements through to the server, thus enabling server-specific behavior.

Important: ALLOWSERVERSELECT behavior was the default for Net Express, and might be required by some applications when migrated to Enterprise Developer.