SQL$HELP72.HLB  —  IMPORT  Arguments  DATA
    Syntax options:

    DATA | NO DATA

    Specifies whether the database created by the IMPORT statement
    includes the data and metadata contained in the source database,
    or the metadata only. DATA is the default.

    When you specify the NO DATA option, you import the metadata
    that defines a database from an .rbr file and exclude the data.
    Duplicating the metadata of a database while excluding the data
    offers the following benefits:

    o  You can use established, tested metadata to create a database
       to store new data. Standardized metadata can be created once
       but used in multiple databases.

    o  You can use the duplicated metadata to test the database
       structure. You can experiment with storage areas and storage
       maps, and by entering sample data, you can test other aspects
       of database structure.

    o  If a database needs testing by someone outside of your group,
       you can submit the database metadata without exposing any
       sensitive data. Also, if the database is very large, you need
       not submit multiple reels of tape to the tester.

                                   NOTE

       The NO DATA option is not compatible with repository
       databases (CDD$DATABASE.RDB). An .rbr file, created by an
       EXPORT statement with the DATA option (the default) and
       generated from a CDD$DATABASE.RDB file, cannot be used with
       the NO DATA option for the IMPORT statement. SQL issues an
       error message stating that the NO DATA option is not valid
       for repository databases.
Close Help