Exporting bulk data You can use the export procedures to export all of the data in a table, or to export LOB data separately from other data. import and export proceduresbulk export bulk export

provides several procedures that you can use to perform bulk-export operations.

  1. To export all the data from a table to a file, use the SYSCS_UTIL.SYSCS_EXPORT_TABLE procedure. The procedure definition is: SYSCS_UTIL.SYSCS_EXPORT_TABLE (IN schemaName VARCHAR(128), IN tableName VARCHAR(128), IN fileName VARCHAR(32672), IN columnDelimiter CHAR(1), IN characterDelimiter CHAR(1), IN codeset VARCHAR(128))No Result is returned from the procedure.
  2. To export the result of a SELECT statement to a file, use the SYSCS_UTIL.SYSCS_EXPORT_QUERY procedure. The procedure definition is: SYSCS_UTIL.SYSCS_EXPORT_QUERY(IN selectStatement VARCHAR(32672), IN tableName VARCHAR(128), IN fileName VARCHAR(32672), IN columnDelimiter CHAR(1), IN characterDelimiter CHAR(1), IN codeset VARCHAR(128))No result is returned from the procedure.