15.10 - FILE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

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.
Name of user-installed file.
Name of database containing the user-installed file (UIF).
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. 

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)