Course Descripiton

StorHouse/RM FTP Data Loader

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

More Information