%SQL.Import.Mgr
class %SQL.Import.Mgr extends %Library.RegisteredObject, %SQL.ExImData
Import Controller for SQL Import.Property Inventory (Including Private)
Method Inventory (Including Private)
- AllocateRoutine()
- BuildIndices()
- CloseImport()
- DeleteImportRoutine()
- ErrorCount()
- ErrorLogClose()
- ErrorLogExecute()
- ErrorLogFetch()
- FileSize()
- GenerateImportRoutine()
- Import()
- ImportRows()
- OpenImport()
- ReadHeader()
- Reset()
Parameters
parameter RTNPREFIX = SQLImport;
Properties (Including Private)
property DeferIndices as %Integer [ InitialExpression = 1 ];
If true, generate indices after importing data using %SortBegin/%SortEnd.
Property methods: DeferIndicesDisplayToLogical(), DeferIndicesGet(), DeferIndicesIsValid(), DeferIndicesLogicalToDisplay(), DeferIndicesNormalize(), DeferIndicesSet()
property IndexPending as %Integer [ Private , InitialExpression = 0 ];
If true, we still need to build indices.
Property methods: IndexPendingDisplayToLogical(), IndexPendingGet(), IndexPendingIsValid(), IndexPendingLogicalToDisplay(), IndexPendingNormalize(), IndexPendingSet()
property UseTransaction as %Integer [ InitialExpression = 0 ];
If true, nest the entire import operation in a transaction.
NOT IMPLEMENTED.
Property methods: UseTransactionDisplayToLogical(), UseTransactionGet(), UseTransactionIsValid(), UseTransactionLogicalToDisplay(), UseTransactionNormalize(), UseTransactionSet()
Methods (Including Private)
Return the name of the routine to use for the import
method BuildIndices() as %Status [ Language = objectscript ]
Perform the merge sort to build the indices.
Call this at the end of the import operation.
method DeleteImportRoutine() as %Status [ Language = objectscript ]
Delete the generated import routine.
method ErrorCount() as %Integer [ Language = objectscript ]
Returns the current number of import errors.
classmethod ErrorLogFetch(ByRef QHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status [ Language = objectscript ]
method FileSize() as %Integer [ Language = objectscript ]
Returns the size of the import file.
method GenerateImportRoutine() as %Status [ Language = objectscript ]
Generate the Import routine.
Do an import from the command line.
method ImportRows(ByRef count As %Integer, ByRef inserted As %Integer, ByRef bytes As %Integer, ByRef done As %Integer, ByRef errorcount As %Integer, total As %Integer) as %Status [ Language = objectscript ]
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.
method OpenImport() as %Status [ Language = objectscript ]
Prepares the start of an import.
Call this after generating an import routine.
method ReadHeader(ByRef header As %String, ByRef size As %Integer) as %Status [ Language = objectscript ]
Reads the first line of the import file.
method Reset() [ Language = objectscript ]
Reset the state of this object.
Queries
query ErrorLog()
Inherited Members
Inherited Properties (Including Private)
- Charset
- ClassName
- ColumnNames
- ColumnTypes
- ColumnWidths
- DateFormat
- Delimiter
- FileName
- HasHeaders
- IQN
- NoCheck
- RoutineName
- StringQuote
- TableName
- Terminator
- TimeFormat
- TimeStampFormat
Inherited Methods (Including Private)
- %AddToSaveSet()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %ConstructCloneInit()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Extends()
- %GetParameter()
- %IsA()
- %IsModified()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnAddToSaveSet()
- %OnClose()
- %OnConstructClone()
- %OnNew()
- %OnValidateObject()
- %OriginalNamespace()
- %PackageName()
- %RemoveFromSaveSet()
- %SerializeObject()
- %SetModified()
- %ValidateObject()
- ResetExImData()