16.20 - Example: Using SYSUIF.UIF_V - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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