Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » System Objects » Views » System views


SYSEXTERNENV system view

SQL Anywhere includes support for six external runtime environments. These include embedded SQL and ODBC applications written in C/C++, and applications written in Java, Perl, PHP, or languages such as C# and Visual Basic that are based on the Microsoft .NET Framework Common Language Runtime (CLR).

Each row in the SYSEXTERNENV system view describes the information needed to identify and launch each of the external environments. The underlying system table for this view is ISYSEXTERNENV.

Column name Column type Description
object_id unsigned bigint

A unique identifier for the external environment.

name varchar(128)

The name of the external environment or language.

scope char(1)

Identifies if the external environment is launched as one-per-connection (C), or one-per-database (D).

support_result_sets char(1)

Identifies the external environments that can return result sets to the user.

location long varchar

Identifies the location where the main executable for the environment can be found.

options long varchar

Identifies the options required on the command line to launch the external environment.

user_id unsigned int

Identifies a user in the database that has DBA authority.

Constraints on underlying system table

PRIMARY KEY (object_id)

FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL

FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)