SQL Anywhere includes support for six external runtime environments. These include embedded SQL and ODBC applications written in C/C++, as well as applications written in Java, Perl, PHP, or languages such as C# and Visual Basic that are based on Microsoft's 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. |
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)
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |