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 1. 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