Exporting and importing data is a common task. IDS offers various utilities to accomplish those jobs. The following article describes the IDS utilities available for data export and import and gives you some advice when to use which tool.

The dbaccess unload and load commands are probably the simplest commands for data export and import. Data is unloaded/loaded to/from ASCII format. Each row in a table produces a separate line in the output file and each column is separated by a delimiter character which can be specified by setting the environment variable DBDELIMITER. The default delimiter character is the pipe sign, i.e. |.