|
IRISLIB database
|
|
|
IRISLIB database
|
|
Import Controller for SQL Import. More...
Public Member Functions | |
| _.Library.Status | AllocateRoutine (_.Library.String rtn) |
| Return the name of the routine to use for the import. | |
| _.Library.Status | BuildIndices () |
| Perform the merge sort to build the indices. | |
| _.Library.Status | CloseImport (_.Library.Integer abort) |
| Call this at the end of the import operation. | |
| _.Library.Status | DeleteImportRoutine () |
| Delete the generated import routine. | |
| _.Library.Integer | ErrorCount () |
| Returns the current number of import errors. | |
| _.Library.Integer | FileSize () |
| Returns the size of the import file. | |
| _.Library.Status | GenerateImportRoutine () |
| Generate the Import routine. | |
| _.Library.Status | Import (_.Library.Boolean savertn) |
| Do an import from the command line. | |
| _.Library.Status | ImportRows (_.Library.Integer count, _.Library.Integer inserted, _.Library.Integer bytes, _.Library.Integer done, _.Library.Integer errorcount, _.Library.Integer total) |
| Reads the next count rows from the import file. More... | |
| _.Library.Status | OpenImport () |
| Prepares the start of an import. More... | |
| _.Library.Status | ReadHeader (_.Library.String header, _.Library.Integer size) |
| Reads the first line of the import file. | |
| Reset () | |
| Reset the state of this object. | |
 Public Member Functions inherited from RegisteredObject | |
| _.Library.Status | OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount) |
| This callback method is invoked when the current object is added to the SaveSet,. More... | |
| _.Library.Status | OnClose () |
| This callback method is invoked by the <METHOD>Close</METHOD> method to. More... | |
| _.Library.Status | OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned) |
| This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More... | |
| _.Library.Status | OnNew () |
| This callback method is invoked by the <METHOD>New</METHOD> method to. More... | |
| _.Library.Status | OnValidateObject () |
| This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More... | |
| Public Member Functions inherited from ExImData | |
| ResetExImData () | |
| Common data used by both SQL import and export classes. More... | |
Public Attributes | |
| DeferIndices | |
| If true, generate indices after importing data using SortBegin/SortEnd. More... | |
| UseTransaction | |
| If true, nest the entire import operation in a transaction. More... | |
| Public Attributes inherited from ExImData | |
| Charset | |
| Character Set to use for import or export. More... | |
| ClassName | |
| Class to use for import/export. More... | |
| ColumnNames | |
| Names (SQL field names) of columns. More... | |
| ColumnTypes | |
| Data types of columns. More... | |
| ColumnWidths | |
| Widths of columns for FixedWidth files. More... | |
| DateFormat | |
| Format for dates (passed to $ZDT). More... | |
| Delimiter | |
| Delimiter character or NULL for fixed width fields. More... | |
| FileName | |
| File (on server) to use for import or export. More... | |
| HasHeaders | |
| If true, file has column headers in first row. More... | |
| IQN | |
| Internal Qualified Table Name. More... | |
| NoCheck | |
| If true, import will insert with NOCHECK. More... | |
| StringQuote | |
| Character used to quote strings or NULL for no quoting. More... | |
| TableName | |
| Table to use for import/export. More... | |
| Terminator | |
| User defined record terminators (upto 8 charectors). More... | |
| TimeFormat | |
| Format for time (passed to $ZTime). More... | |
| TimeStampFormat | |
| Format for datetime values (ODBC or T-SQL). More... | |
Private Attributes | |
| __IndexPending | |
| If true, we still need to build indices. More... | |
Additional Inherited Members | |
| Static Public Attributes inherited from RegisteredObject | |
| CAPTION = None | |
| Optional name used by the Form Wizard for a class when generating forms. More... | |
| JAVATYPE = None | |
| The Java type to be used when exported. | |
| PROPERTYVALIDATION = None | |
| This parameter controls the default validation behavior for the object. More... | |
| _.Library.Status ImportRows | ( | _.Library.Integer | count, |
| _.Library.Integer | inserted, | ||
| _.Library.Integer | bytes, | ||
| _.Library.Integer | done, | ||
| _.Library.Integer | errorcount, | ||
| _.Library.Integer | total | ||
| ) |
Reads the next count rows from the import file.
On return, counts contains the number of rows read from the file. inserted contains the number of rows successfully inserted. bytes contains the number of bytes read from the file. done is set to one when the import is complete. errorcount is the cumulative number of INSERT errors encountered.
| _.Library.Status OpenImport | ( | ) |
Prepares the start of an import.
Call this after generating an import routine.
| DeferIndices |
If true, generate indices after importing data using SortBegin/SortEnd.
|
private |
If true, we still need to build indices.
| UseTransaction |
If true, nest the entire import operation in a transaction.
NOT IMPLEMENTED.
1.9.1