Class Hierarchy    Previous  Next  Index

Class COM.cloudscape.tools.FileImport

java.lang.Object
    |
    +----COM.cloudscape.vti.VTITemplate
            |
            +----COM.cloudscape.tools.ImportExportImpl.ImportAbstractResultSet
                    |
                    +----COM.cloudscape.tools.ImportExportImpl.ImportAbstract
                            |
                            +----COM.cloudscape.tools.FileImport

public class FileImport
extends COM.cloudscape.tools.ImportExportImpl.ImportAbstract
Copyright © 1998-2000, Informix Software, Inc. All rights reserved.

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.


Variable Index

 o INSERT_MODE_PROPERTY
 

Constructor Index

 o FileImport(String)
Invoke import from ij
 o FileImport(String, String)
Invoke import from ij

Method Index

 o defaultControlFileReader()
For internal use only
 o getControlFileReader()
For internal use only
 o getImportReadData()
virtual method from the abstract class
 o Import(Connection, String, String)
Invoke import from ij or from a Java application
 o Import(Connection, String, String, Properties)
Invoke import from ij or from a Java application
 o Import(Connection, String, String, String)
Invoke import from ij or from a Java application
 o Import(Connection, String, String, String, Properties)
Invoke import from ij or from a Java application
 o ImportInit()
initialize method of all import methods - init the appUI object and get an handler on the resource file.
 o ImportInitInstance()
 
 o main(String[])
This is for stand-alone bulk import from the command line.
 o slowImport(Connection, String, String)
for internal use only
 o slowImport(Connection, String, String, String)
for internal use only

Field Detail

 o INSERT_MODE_PROPERTY
public static final java.lang.String INSERT_MODE_PROPERTY

Constructor Detail

 o FileImport
public FileImport(java.lang.String inputFileName) throws java.lang.Exception
          Invoke import from ij
Parameters:
inputFileName - The URL of the ASCII file from which import will happen
Throws:
java.lang.Exception - on error
 o FileImport
public FileImport(java.lang.String inputFileName,
                  java.lang.String controlFileName) throws java.lang.Exception
          Invoke import from ij
Parameters:
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.
Throws:
java.lang.Exception - on error

Method Detail

 o Import
public static void Import(java.sql.Connection connection,
                          java.lang.String entityName,
                          java.lang.String inputFileName) throws java.lang.Exception
          Invoke import from ij or from a Java application
Parameters:
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
Throws:
java.lang.Exception - on error
 o Import
public static void Import(java.sql.Connection connection,
                          java.lang.String entityName,
                          java.lang.String inputFileName,
                          java.util.Properties prop) throws java.lang.Exception
          Invoke import from ij or from a Java application
Parameters:
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"
Throws:
java.lang.Exception - on error
 o 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
          Invoke import from ij or from a Java application
Parameters:
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.
Throws:
java.lang.Exception - on error
 o 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
          Invoke import from ij or from a Java application
Parameters:
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"
Throws:
java.lang.Exception - on error
 o slowImport
public static void slowImport(java.sql.Connection connection,
                              java.lang.String entityName,
                              java.lang.String inputFileName) throws java.lang.Exception
          for internal use only
Throws:
java.lang.Exception - on error
 o slowImport
public static void slowImport(java.sql.Connection connection,
                              java.lang.String entityName,
                              java.lang.String inputFileName,
                              java.lang.String controlFileName) throws java.lang.Exception
          for internal use only
Throws:
java.lang.Exception - on error
 o main
public static void main(java.lang.String args[]) throws java.lang.Exception
          This is for stand-alone bulk import from the command line.
Parameters:
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
Throws:
java.lang.Exception - on error
 o getControlFileReader
protected COM.cloudscape.tools.ImportExportImpl.ControlFileReaderAbstract getControlFileReader() throws java.lang.Exception
          For internal use only
Throws:
java.lang.Exception - on error
Overrides:
getControlFileReader in class COM.cloudscape.tools.ImportExportImpl.ImportAbstract
 o defaultControlFileReader
protected boolean defaultControlFileReader() throws java.lang.Exception
          For internal use only
Throws:
java.lang.Exception - on error
Overrides:
defaultControlFileReader in class COM.cloudscape.tools.ImportExportImpl.ImportAbstract
 o getImportReadData
protected COM.cloudscape.tools.ImportExportImpl.ImportReadDataAbstract getImportReadData() throws java.lang.Exception
          virtual method from the abstract class
Throws:
java.lang.Exception - on error
Overrides:
getImportReadData in class COM.cloudscape.tools.ImportExportImpl.ImportAbstract
 o ImportInit
protected static void ImportInit()
          initialize method of all import methods - init the appUI object and get an handler on the resource file.
 o ImportInitInstance
protected void ImportInitInstance()

  Class Hierarchy    Previous  Next  Index