| java.lang.Object
 org.apache.derby.impl.load.ExportAbstract
org.apache.derby.impl.load.Export
| Export | | public class Export extends ExportAbstract (Code) | | This class provides ways to export data from
a table or a view into a file. Export functions provided
in this class are called through Systement Procedures.
|
| Method Summary | |
| public static void | exportQuery(Connection con, String selectStatement, String outputFileName, String columnDelimeter, String characterDelimeter, String codeset)
SYSCS_EXPORT_QUERY system Procedure from ij or from a Java application
invokes this method to perform export of the data retrieved by select statement to a file. | | public static void | exportTable(Connection con, String schemaName, String tableName, String outputFileName, String columnDelimeter, String characterDelimeter, String codeset)
SYSCS_EXPORT_TABLE system Procedure from ij or from a Java application
invokes this method to perform export of a table data to a file. | | protected ExportWriteDataAbstract | getExportWriteData()
|
| exportQuery | | public static void exportQuery(Connection con, String selectStatement, String outputFileName, String columnDelimeter, String characterDelimeter, String codeset) throws SQLException(Code) | | SYSCS_EXPORT_QUERY system Procedure from ij or from a Java application
invokes this method to perform export of the data retrieved by select statement to a file.
Parameters:
con - The Cloudscape database connection URL for the database containing the table
Parameters:
selectStatement - select query that is used to export the data
Parameters:
outputFileName - Name of the file to which data has to be exported.
Parameters:
columnDelimeter - Delimiter that seperates columns in the output file
Parameters:
characterDelimeter - Delimiter that is used to quiote non-numeric types
Parameters:
codeset - Codeset that should be used to write the data to the file
exception:
SQL - Exception on errors |
| exportTable | | public static void exportTable(Connection con, String schemaName, String tableName, String outputFileName, String columnDelimeter, String characterDelimeter, String codeset) throws SQLException(Code) | | SYSCS_EXPORT_TABLE system Procedure from ij or from a Java application
invokes this method to perform export of a table data to a file.
Parameters:
con - The Cloudscape database connection URL for the database containing the table
Parameters:
schemaName - schema name of the table data is being exported from
Parameters:
tableName - Name of the Table from which data has to be exported.
Parameters:
outputFileName - Name of the file to which data has to be exported.
Parameters:
columnDelimeter - Delimiter that seperates columns in the output file
Parameters:
characterDelimeter - Delimiter that is used to quoate non-numeric types
Parameters:
codeset - Codeset that should be used to write the data to the file
exception:
SQL - Exception on errors |
|
|