The user installed files (UIF_V) view in the SYSUIF database is based on the DBC.UIF_INFO table. This view identifies the user installed files (UIFs) defined on the system that are accessible to the current user or database.
View Definition
This table lists and describes the columns of the view.
| View Column | Data Type | Format | Source Table.Column |
|---|---|---|---|
| DatabaseId | BYTE(4) NOT NULL |
X(8) | Dbase.DatabaseId |
| TVMNameI | VARCHAR(128) NOT NULL |
X(128) | TVM.NameI |
| UIFID | BYTE(6) NOT NULL |
X(12) | UIF_INFO.UIFID |
Example: Using SYSUIF.UIF_V
The following SELECT statement displays the UIFs that are accessible by database or user ID 00000104.
SELECT * from sysuif.uif_v;
Result:
DatabaseId 00000104 UIFFileName r2.r TVMNameI R2 UIFId 0000060A0000 DatabaseId 00000104 UIFFileName p1.py TVMNameI P1 UIFId 0000070A0000