![]() |
Using the Bulk Import and Export Utilities
|
|
insertModeFunctionUse the insertMode property during bulk import to specify whether to use Cloudscape's fast import mode (which allows Cloudscape to use minimal logging and under-the-cover performance enhancements). Fast import mode can significantly improve performance. The legal values for this property are bulkInsert and replace. Use the replace setting to perform a fast import. Use bulkInsert to insert data into an empty table or to add data to a non-empty table. Use replace to replace data in an existing table. If a table is empty, you can explicitly set this property when working within the context of an SQL-J statement. Otherwise, the utility sets insertMode to bulkInsert by default. If the table is not empty, you must specify to replace existing data to work in fast import mode. To replace data, you must explicitly set this property to replace.
SyntaxinsertMode={ bulkInsert | replace } When the insertMode property is set, Cloudscape creates a new physical container for the table, which is more efficient than re-using the existing container. NOTE: Cloudscape ignores the insertMode property if any of the requirements for fast import mode are not met. See Fast Mode Requirements. If you specify insertMode=replace when requirements for fast import mode are not met, Cloudscape throws an exception. NOTE: If you specify insertMode=replace, Cloudscape resets its internal counter for any autoincrement default columns to the initial value defined for the column. Since Cloudscape is replacing data, values in the column with the autoincrement default "start over" at the beginning (by default, 1). NOTE: You can turn on bulkInsert even when you are not using the import utilities. For example, you may want to turn on bulkInsert when selecting data from another table or selecting data from an external virtual table. See "INSERT statement" in the Cloudscape Reference Manual. If the insertMode property is set to bulkInsert, you can also specify an integer value for the bulkFetch property. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |