15.10 - User Installed Files View - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

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

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