Dbload command file example

Only "btree" is allowed. All rights reserved. Skip navigation links. Berkeley DB Java Edition version 7. Object com. DbLoad public class DbLoad extends java. Object Loads a database from a dump file generated by DbDump.

This utility may be used programmatically or from the command line. String[] for a full description of the command line arguments. Specifies the number of bad rows that dbload reads before terminating. The default value for errors is References: For more information, see Bad-Row Limit. References: For more information, see Rows to Ignore. Instructs dbload to lock the tables listed in the command file in exclusive mode during the load operation.

References: For more information, see Table Locking. Restrictions: If you specify an existing file, its contents are overwritten. Migration to OneDB 2. External tables are the fastest method for loading data into a RAW table with no indexes. The dbexport and dbimport utilities The dbexport and dbimport utilities import and export a database and its schema to disk or tape.

Syntax of the dbload command The dbload command loads data into databases or tables. Command file for the dbload utility Before you use the dbload utility, you must create a command file that names the input data files and the tables that receive the data.

The command file maps fields from one or more input files into columns of one or more tables within your database. Using the dbload utility with unnamed row types You can use the dbload utility with unnamed row types, which are created with the ROW constructor and define the type of a column or field.

The dbschema utility The dbschema utility displays the SQL statements the schema that are necessary to replicate database objects. Migrating existing keystores. Tip: To find the number of fields in an unloaded table that contains a named row type, count the number of fields between each vertical bar delimiter.