Automated Procedures

Topics:

This chapter describes the following procedures:

  • The AUTODB2 facility for DB2 creates Master and Access Files for existing DB2 tables.
  • The AUTODBC facility creates Master and Access Files for existing Teradata tables.
  • The FOCUS CREATE FILE command creates an RDBMS table from the description in an existing Master and Access File.

The AUTO facilities use RDBMS catalog definitions of existing tables or views, along with user selections, to generate Master and Access Files (see Creating File Descriptions). The AUTODB2 and AUTODBC facilities work with any RDBMS release.

Note: Do not use a Master File created (by AUTODB2 or AUTODBC) in one FOCUS release together with an Access File created in a different FOCUS release.

The FOCUS CREATE FILE command uses existing Master and Access Files to generate an RDBMS table definition. CREATE FILE also generates a unique index if the KEYS value in the Access File is greater than zero (see Creating Tables: The CREATE FILE Command).


Information Builders