UltraLiteJ Database Load utility (ULjLoad)

Provides the capability to load an UltraLiteJ database from an XML source file. The XML file is often produced by the ULjUnload utility and is customizable.

Database configuration parameters

Database configuration parameters cannot be set in the command line. ULjLoad uses the default configuration when a new database is created. If you need to create a database with different configuration parameters, such as a different page size, you must create the database in Java first and then use ULjLoad -a to load the XML content into the database you created.

Syntax

ULjLoad -c filename -p password [ options ] inputfile

Option	Description
-a	Add information from XML file to an existing database. If this option is not specified, a new database is created.
-c filename	Required. Name of database file.
-d	Load data only; ignore schema information.
-f directory	Directory to retrieve data for columns larger than max blob size specified with -b option during ULjUnload.
-i	Insert rows for upload synchronization.
-n	Load schema information only; ignore row data.
-p password	Optional. The default password is DBA.
-q	Run in quiet mode—do not display messages.
-v	Display verbose messages.
-y	Overwrite output file if it exists (and -a option is not specified).
-?	Display command line usage information.
inputfile	Input file containing xml statements.

Example for loading blobfile types

This example assumes that you have applied the following SQL statement to your UltraLiteJ database and unloaded the file using the UltraLiteJ database unload utility. For more information about this example and unloading blobfile types, see UltraLiteJ Database Unload utility (ULjUnload).

CREATE TABLE blobfile_example
    file_name CHAR(size) DEFAULT AUTOFILENAME( prefix, extension ),
    file_contents LONG BINARY STORE AS FILE( file_name ) [ CASCADE DELETE ]

ULLoad, while encountering a file exported by ULjUnload, treats the file_name column as a CHAR column and the file_contents column as a LONG BINARY column.

ULjLoad, while encountering the sam XML file, reconstructs the blobfile type. The file_name column stores the string <base_dir>/<reference_to_external_file>, where <base_dir> is the exact string in the -f option, and <reference_to_external_file> is the exact string found in the file_contents column in the XML file. The newly constructed database then contains valid references to the external files.

The load fails with an error message prompting the user to increase the size of the file_name column if the generated file name is too long.

Example

The -? option displays command line information.

uljload -?

When the ULjLoad utility command line includes the -? option, the following usage information appears:

SQL Anywhere UltraLiteJ Database Load Utility
Usage: uljload [options] <XML file>
        Create and load data into a new UltraLite J database from <XML file>.

Options:
        -a      Add to existing database.
        -c      <file> Database file.
        -d      Data only -- ignore schema.
        -f      <directory>
                Directory for loading .File paths.
        -i      Insert rows for upload synchronization.
        -n      Schema only -- ignore data.
        -p      Password to connect to database.
        -q      Quiet: do not print messages.
        -v      Verbose messages.
        -y      Overwrite file if it already exists.

Discuss this page in DocCommentXchange.