![]() |
Using the Bulk Import and Export Utilities
|
|
Bulk Import and Export Stand-Alone UtilitiesThe syntax for the standalone bulk-import utility is: java [-D importProperties ] COM.cloudscape.tools.FileImport The syntax for the standalone bulk-export utility is: java COM.cloudscape.tools.FileExport databaseConnectionURL NOTE: You can set system properties such as cloudscape.system.home on the command line using parameters to the java command. Arguments to Import and Export Utility Commands
Bulk Import and Export Utility ExamplesNOTE: Type commands on a single line, with no carriage returns. java COM.cloudscape.tools.FileImport jdbc:cloudscape:toursDB Imports c:\mydata\mydata.dat into the table myints in the schema APP in the database toursDB. java -DinsertMode=replace COM.cloudscape.tools.FileImport Imports mydata2.dat into the table in abc in the schema APP, replacing existing data and running in fast mode in the database wombat using the control file c:\data\myData.ctl. java -Dcloudscape.system.home=c:\mydatabases Imports flight.info via HTTP into the table Flights in the database toursDB, which is located in the specified system directory. java COM.cloudscape.tools.FileExport jdbc:cloudscape:wombat Exports data from table or view abc in database wombat to file c:\mydata\mydata3.dat, using the default format (since no control file is specified). java COM.cloudscape.tools.FileExport jdbc:cloudscape:wombat Exports from table or view abc in database wombat to file mydata4.dat using the file format described in mydata.ctl. |
|
![]() 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. |