Duration:
1/2 day
This course teaches students how to load data into user tables and indexes
in a StorHouse/RM database with a "bulk" load operation from a UNIX or
Windows host. The bulk load operation is performed by the FTP Data Loader
utility which uses standard as well as customized FTP commands to transfer
control files and data to StorHouse/RM in order to load tables and build
indexes. This course also covers the StorHouse FTP Data Unloader to unload
data from a StorHouse/ RM database to an output file. This course assumes
an understanding of standard FTP functionality.
Prerequisites:
StorHouse/RM System and Database Administration
Course
Objectives:
Upon completion of this course the students will:
Understand the architecture, use and features of the FileTek FTP Data
Loader
Understand
the steps used to load data into StorHouse/RM user tables and to build
indexes
Understand
the FTP Data Loader control file and the syntax of the LOAD INTO TABLE
statement
Know
how to format the FTP Data Loader "put" command to pass the control
file and data file to the server
Understand the segment management features of the FTP Data Loader
Be able to confirm, restart, or abort a database load
Know
how to format the FTP Data UnLoader "put" and "get" commands to pass
the control file and create a data file
