SYSEXTERNENVOBJECT system view

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	This column identifies the creator/owner of the external object.
name	LONG VARCHAR	This column identifies the name of the external object as specified in the INSTALL EXTERNAL OBJECT statement.
contents	LONG BINARY	The contents of the external object.
update_time	TIMESTAMP	This column identifies the last local time the object was modified (or installed).
update_time_utc	TIMESTAMP WITH TIME ZONE	This column identifies the last UTC time the object was modified (or installed).

Constraints on underlying system table

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)

SYSEXTERNENVOBJECT system view

Constraints on underlying system table

See also