Moving data between computers and dbspaces

You can move data between different computers, and you can import data from environments other than the HCL OneDB™ database server. Except when you use external tables, you must unload your data to ASCII files before you move the data to another computer.

If you are moving data into the HCL OneDB database server on another computer, you can use the dbimport and dbload utilities to load the data that you exported.

If you are moving data to an application that is not based on HCL OneDB, you might need to use the UNLOAD statement because you can specify the delimiter that is used in the data files.