SYSTEM_OBJECT_TYPES table

The SYSTEM_OBJECT_TYPES table returns a list of external object types found on IBM i.

Additional information about object types is available at this link: External object types

Authorization: None required.

The following table describes the columns in the table. The system name is OBJ_TYPES. The schema is QSYS2.

Table 1. SYSTEM_OBJECT_TYPES table
Column Name	System Column Name	Data Type	Description
OBJECT_TYPE	OBJTYPE	VARCHAR(7)	System object type.
TEXT_DESCRIPTION	TEXT	VARCHAR(60)	Description of the object type.
CATEGORY	CATEGORY	VARCHAR(7)	Category of object type. IFS The object type resides in the integrated file system (IFS). LIBRARY The object type resides in a library.

Example

List all the system object types that are found in libraries:

SELECT * FROM QSYS2.SYSTEM_OBJECT_TYPES
  WHERE CATEGORY = 'LIBRARY';