Load Data and Definitions option

Choose this option to load table definitions for specified tables or for all the tables in the database.

Note: The Data Dictionary allows you to load data definition files (.df) greater than 2GB on platforms where ABL supports large files.

When a menu option prompts you for a filename only, you can specify a complete pathname.

The following table describes the menu that appears when you choose this option. More detailed descriptions of the options follow the table.

Table 27. Load Data and Definitions menu
Menu options	Task performed
Data Definitions (.df file)...	Loads table, auto-connect record, sequence, and collation table definitions
Table Contents (.d file)...	Loads table contents
SQL Views...	Loads SQL view contents
User Table Contents...	Loads user table contents
Security Authentication Records	Loads data into the security authentication system and domain tables
Security Permissions	Loads roles and granted permissions records
Sequences Current Values...	Loads sequence values
Reconstruct Bad Load Records...	Uses the error file and the original data file to build a new data file for bad records
Database Identification Properties	Loads database identification information
Database Options	Loads database security and auditing settings
Audit Policies	Loads audit policies as XML, text, or load application audit event data
Audit Data	Loads recorded audit data

In this section: