UltraLite Java Edition Database Load utility (ULjLoad)

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

Note

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	Adds information from the XML file to an existing database. If this option is not specified, a new database is created.
-c filename	Required. Specifies the name of the database file.
-d	Loads data only; ignore schema information.
-f directory	Specifies the directory to retrieve data for columns larger than max blob size specified with -b option during ULjUnload.
-i	Inserts rows for upload synchronization.
-n	Loads schema information only; ignores row data.
-p password	Optional. Specifies the password. The default password is sql.
-q	Runs the utility in quiet mode—does not display messages.
-v	Displays verbose messages.
-y	Overwrites the output file if it exists (and -a option is not specified).
-z pagesize	Specifies the page size, in bytes, to create the database with.
-?	Displays command line usage information.
inputfile	Specifies the input file that contains XML statements.

Example for loading blobfile types

This example assumes that you have applied the following SQL statement to your UltraLite Java edition database and unloaded the file using the UltraLite Java edition database unload utility.

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 same 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 UltraLiteJ 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. 
        -z <page size>
                Page size to create the database with.
        -y      Overwrite file if it already exists.

Discuss this page in DocCommentXchange.