15.10 - FILE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Display the text associated with the installed file and display the DDL used to install the file.

Binary user-installed files (UIF) are not displayed.
uif_name
Name of user-installed file.
database_name
Name of database containing the user-installed file (UIF).
user_name
Name of user containing the user-installed file (UIF).

Example: Show User Installed File (UIF)

This is example of SHOW FILE for a user installed file (UIF).

SHOW FILE mapper;

 *** Text of DDL statement returned. 
----------------------------------------------------------------------------------
CALL SYSUIF.INSTALL_FILE('mapper','mapper.py','cz!mapper.py!/tmp/mapper.py')

 *** Text of DDL statement returned. 
----------------------------------------------------------------------------------
#!/usr/bin/python

import sys

# input comes from STDIN (standard input)
for line in sys.stdin:
    # remove leading and trailing whitespace
    line = line.strip()
    # split the line into words
    words = line.split()
    # increase counters
    for word in words:
        # write the results to STDOUT (standard output);
        # what we output here will be the input for the
        # Reduce step, i.e. the input for reducer.py
        #
        # tab-delimited; the trivial word count is 1
        print '%s\t%s' % (word, 1)