|
IRISLIB database
|
|
|
IRISLIB database
|
|
Import Controller for SQL Import. More...
Public Member Functions | |
| _.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. | |
| 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) |
| 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 SQLExImData | |
| ResetExImData () | |
| Reset the export/import data. | |
Public Attributes | |
| DeferIndices | |
| If true, generate indices after importing data. More... | |
| UseTransaction | |
| If true, nest the entire import operation in a transaction. More... | |
| Public Attributes inherited from SQLExImData | |
| 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... | |
| 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... | |
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... | |
Import Controller for SQL Import.
| _.Library.Status ImportRows | ( | _.Library.Integer | count, |
| _.Library.Integer | inserted, | ||
| _.Library.Integer | bytes, | ||
| _.Library.Integer | done, | ||
| _.Library.Integer | errorcount | ||
| ) |
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.
|
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