Methods for running the import and export procedures You can run the import and export procedures from within an SQL statement using ij or any Java application. bulk import and exportmethods for running procedures import proceduresmethods for running export proceduresmethods for running bulk import and exportclient/server mode import proceduresclient/server mode export proceduresclient/server mode

The import and export procedures read and write text files, and if you use an external file when you import or export data, you can also import and export blob data. The import procedures do not support read-once streams (live data feeds), because the procedures read the first line of the file to determine the number of columns, then read the file again to import the data.

The import and export procedures are server-side utilities that exhibit different behavior in client/server mode. Typically, you use these procedures to import data into and export data from a locally running database. However, you can use the import and export procedures when is running in a server framework if you specify import and export files that are accessible to the server.