User's Guide

Part VI. SQL Anywhere Reference

Chapter 39. SQL Anywhere Components

With the Uncompression utility you can expand a compressed database file created by the Compression utility. The Uncompression utility reads the given compressed database file and creates an uncompressed database file.

The Uncompression utility does not uncompress files other than the main database file (dbspace files).

You can access the Uncompression utility in the following ways:

• From Sybase Central, for interactive use under Windows 95 or NT.
• From the ISQL Database Tools window.
• From the ISQL DBTOOL statement.
• From the system command line, using the DBEXPAND command-line utility. This is useful for incorporating into batch or command files.

Uncompressing a database in Sybase Central

To uncompress a compressed database file:

1. Open the Database Utilities folder in the left panel.
2. Double-click Uncompress Database in the right panel. The Uncompress Wizard is displayed.
3. Follow the instructions in the Wizard.

For full information on uncompressing a database in Sybase Central, see the Sybase Central online Help.

Uncompressing a database from the ISQL Database Tools window

To use the Uncompression utility from the ISQL Database Tools window:

1. Select Database Tools from the Window menu.
2. Click Uncompress Database on the Tools list.
3. Enter the database filename (with path).
4. Click Uncompress, and enter a filename to use for the uncompressed database.
5. Click OK to uncompress the selected database file.

Uncompressing a database using the DBTOOL statement

Syntax

The syntax for the Uncompression utility from the ISQL DBTOOL statement is as follows:

     DBTOOL UNCOMPRESS DATABASE compressed-database-file

         ...    [ TOfilename ] [ NOCONFIRM ]

Example

The following statement uncompresses the compressed database file C:\TEMP.CDB, creating the database file C:\TEMP.DB

     DBTOOL UNCOMPRESS DATABASE 'c:\temp.cdb'

The DBEXPAND command-line utility

Syntax

     dbexpand [switches] compressed-database-file [database-file]

Windows 3.x syntax

     dbexpanw [switches] compressed-database-file [database-file]

Switch	Description
-q	Operate quietly---do not print messages
-y	Erase existing output file without confirmation

The input filename extension defaults to CDB. The output filename (with extension) must not have the same name as the input filename (with extension).

  For more information about the command-line switches, see "Uncompression utility options".

Uncompression utility options

Output log messages to file (-o ) Redirect log messages to the named file. Do not display messages on a window. For the DBEXPAND command-line utility, this is the -q command-line switch. This option is available only from the command-line utility.

Operate without confirming actions (-y ) Without this option, you are prompted to confirm the replacement of an existing database file.