| org.apache.derby.impl.load.ImportAbstract
 org.apache.derby.impl.load.Import
| Import | | public class Import extends ImportAbstract (Code) | | This class implements import of data from a URL into a table.
Import functions provided here in this class shouble be called through
Systement Procedures. Import uses VTI , which is supprted only through
Systemem procedures mechanism.
|
| Method Summary | |
| ImportReadData | getImportReadData()
| | public static void | importData(Connection connection, String schemaName, String tableName, String insertColumnList, String columnIndexes, String inputFileName, String columnDelimiter, String characterDelimiter, String codeset, short replace)
SYSCS_IMPORT_DATA system Procedure from ij or from a Java application
invokes this method to perform import to a table from a file.
Parameters:
connection - The Cloudscape database connection URL for the database containing the table
Parameters:
schemaName - The name of the schema where table to import exists
Parameters:
tableName - Name of the Table the data has to be imported to.
Parameters:
insertColumnList - Comma Seperated column name list to which datahas to be imported from file.eg: 'c2,c2,'c3'.
Parameters:
columnIndexes - Comma sepearted Lit Index of the columns in the file(first columnstarts at 1). | | public static void | importTable(Connection connection, String schemaName, String tableName, String inputFileName, String columnDelimiter, String characterDelimiter, String codeset, short replace)
SYSCS_IMPORT_TABLE system Procedure from ij or from a Java application
invokes this method to perform import to a table from a file. |
| Import | | public Import(String inputFileName, String columnDelimiter, String characterDelimiter, String codeset, int noOfColumnsExpected) throws SQLException(Code) | | Constructior to Invoke Import from a select statement
Parameters:
inputFileName - The URL of the ASCII file from which import will happen
exception:
Exception - on error |
| importData | | public static void importData(Connection connection, String schemaName, String tableName, String insertColumnList, String columnIndexes, String inputFileName, String columnDelimiter, String characterDelimiter, String codeset, short replace) throws SQLException(Code) | | SYSCS_IMPORT_DATA system Procedure from ij or from a Java application
invokes this method to perform import to a table from a file.
Parameters:
connection - The Cloudscape database connection URL for the database containing the table
Parameters:
schemaName - The name of the schema where table to import exists
Parameters:
tableName - Name of the Table the data has to be imported to.
Parameters:
insertColumnList - Comma Seperated column name list to which datahas to be imported from file.eg: 'c2,c2,'c3'.
Parameters:
columnIndexes - Comma sepearted Lit Index of the columns in the file(first columnstarts at 1). eg: '3 ,4 , 5'
Parameters:
inputFileName - Name of the file from which data has to be imported.
Parameters:
columnDelimiter - Delimiter that seperates columns in the file
Parameters:
characterDelimiter - Delimiter that is used to quiote non-numeric types
Parameters:
codeset - Codeset of the data in the file
Parameters:
replace - Indicates whether the data in table has to be replaced orappended.(0 - append , > 0 Replace the data)
exception:
SQL - Exception on errors |
| importTable | | public static void importTable(Connection connection, String schemaName, String tableName, String inputFileName, String columnDelimiter, String characterDelimiter, String codeset, short replace) throws SQLException(Code) | | SYSCS_IMPORT_TABLE system Procedure from ij or from a Java application
invokes this method to perform import to a table from a file.
Parameters:
connection - The Cloudscape database connection URL for the database containing the table
Parameters:
schemaName - The name of the schema where table to import exists
Parameters:
tableName - Name of the Table the data has to be imported to.
Parameters:
inputFileName - Name of the file from which data has to be imported.
Parameters:
columnDelimiter - Delimiter that seperates columns in the file
Parameters:
characterDelimiter - Delimiter that is used to quiote non-numeric types
Parameters:
codeset - Codeset of the data in the file
Parameters:
replace - Indicates whether the data in table has to be replaced orappended.(0 - append , > 0 Replace the data)
exception:
SQL - Exception on errors |
|
|