Many external runtime environments are supported, including 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 SYSEXTERNENVOBJECT system view describes an installed external object. The underlying system table for this view is ISYSEXTERNENVOBJECT.
| Column name | Data type | Description |
|---|---|---|
| object_id | unsigned bigint | A unique identifier for the external object. |
| extenv_id | unsigned bigint | The unique identifier for the external environment (SYSEXTERNENV.object_id). |
| owner | unsigned int | Identifies the creator/owner of the external object. |
| name | long varchar | Identifies the name of the external object as specified in the INSTALL statement. |
| contents | long binary | The contents of the external object. |
| update_time | timestamp | Identifies the last time the object was modified (or installed). |
PRIMARY KEY (object_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
FOREIGN KEY (extenv_id) references SYS.ISYSEXTERNENV (object_id)
FOREIGN KEY (owner) references SYS.ISYSUSER (user_id)
UNIQUE Index (name)