Class Hierarchy Previous Next Index
java.lang.Object | +----COM.cloudscape.vti.VTITemplate | +----COM.cloudscape.tools.ImportExportImpl.ImportAbstractResultSet | +----COM.cloudscape.tools.ImportExportImpl.ImportAbstract | +----COM.cloudscape.tools.FileImport
This class provides ways for importing data from a URL into a table. Another class in the same package(FileExport) exports data from a table or a view into a file.
This can be "run" within Cloudview, an SQL statement using ij, any Java application, or on command line. The user documentation gives details and examples of the various ways of using this class.
public static final java.lang.String INSERT_MODE_PROPERTY
public FileImport(java.lang.String inputFileName) throws java.lang.Exception
inputFileName
- The URL of the ASCII file from which import will happen
public FileImport(java.lang.String inputFileName, java.lang.String controlFileName) throws java.lang.Exception
inputFileName
- The URL of the ASCII file from which import will happen
controlFileName
- The URL of the control file specifying the file format of the
ASCII file for the bulk import.
public static void Import(java.sql.Connection connection, java.lang.String entityName, java.lang.String inputFileName) throws java.lang.Exception
con
- The Cloudscape database connection URL for the database containing the table
entityName
- The name of the table into which you want to bulk import
the data. Qualify the table name with the schema name, if it is
not in the default schema APP.
inputFileName
- The URL of the ASCII file from which import will happen
public static void Import(java.sql.Connection connection, java.lang.String entityName, java.lang.String inputFileName, java.util.Properties prop) throws java.lang.Exception
con
- The Cloudscape database connection URL for the database containing the table
entityName
- The name of the table into which you want to bulk import
the data. Qualify the table name with the schema name, if it is
not in the default schema APP.
inputFileName
- The URL of the ASCII file from which import will happen
prop
- enables "fast import"
public static void Import(java.sql.Connection connection, java.lang.String entityName, java.lang.String inputFileName, java.lang.String controlFileName) throws java.lang.Exception
con
- The Cloudscape database connection URL for the database containing the table
entityName
- The name of the table into which you want to bulk import
the data. Qualify the table name with the schema name, if it is
not in the default schema APP.
inputFileName
- The URL of the ASCII file from which import will happen
controlFileName
- The URL of the control file specifying the file format of the
ASCII file for the bulk import.
public static void Import(java.sql.Connection connection, java.lang.String entityName, java.lang.String inputFileName, java.lang.String controlFileName, java.util.Properties prop) throws java.lang.Exception
con
- The Cloudscape database connection URL for the database containing the table
entityName
- The name of the table into which you want to bulk import
the data. Qualify the table name with the schema name, if it is
not in the default schema APP.
inputFileName
- The URL of the ASCII file from which import will happen
controlFileName
- The URL of the control file specifying the file format of the
ASCII file for the bulk import.
prop
- enables "fast import"
public static void slowImport(java.sql.Connection connection, java.lang.String entityName, java.lang.String inputFileName) throws java.lang.Exception
public static void slowImport(java.sql.Connection connection, java.lang.String entityName, java.lang.String inputFileName, java.lang.String controlFileName) throws java.lang.Exception
public static void main(java.lang.String args[]) throws java.lang.Exception
databaseConnectionURL
- The Cloudscape database connection URL for the database
containing the table
tableOrViewName
- The name of the table into which you want to bulk import
the data. Qualify the table name with the schema name, if it is
not in the default schema APP.
exportFile
- The URL of the ASCII file into which import will happen
protected COM.cloudscape.tools.ImportExportImpl.ControlFileReaderAbstract getControlFileReader() throws java.lang.Exception
protected boolean defaultControlFileReader() throws java.lang.Exception
protected COM.cloudscape.tools.ImportExportImpl.ImportReadDataAbstract getImportReadData() throws java.lang.Exception
protected static void ImportInit()
protected void ImportInitInstance()
Class Hierarchy Previous Next Index