InterSystems IRIS Data Platform 2020.4 > Class Reference > %SYS namespace > %SQL.Export.Mgr

%SQL.Export.Mgr

class %SQL.Export.Mgr extends %Library.RegisteredObject, %SQL.ExImData

Export Controller for SQL Export.

Property Inventory

Method Inventory

Parameters

parameter RTNPREFIX = SQLExport;

Properties

property IsExporting as %Boolean [ InitialExpression = 0 ];
Private flag set to True when export is underway.
Property methods: IsExportingDisplayToLogical(), IsExportingGet(), IsExportingIsValid(), IsExportingLogicalToDisplay(), IsExportingNormalize(), IsExportingSet()

Methods

method CheckTimeVersion() as %Boolean [ Language = objectscript ]
Check compatibility to see if server have ..TimeFormat
method CloseExport() as %Status [ Language = objectscript ]
Call this at the end of the export operation.
method DeleteExportRoutine() as %Status [ Language = objectscript ]
Delete the generated export routine.
method Export(savertn As %Boolean = 0) [ Language = objectscript ]
Do an export from the command line.
method ExportRows(ByRef rows As %Integer, ByRef done As %Integer) as %Status [ Language = objectscript ]
Exports the next rows rows to the export file. On return, rows contains the number of rows exported or 0 if the export is complete.
method GenDataExpr(col As %Integer, colno As %Integer) as %String [ Language = objectscript ]
Compute and return the correct expression for column col.

colno is the number of the actual exported column (some columns may be skipped.

method GenerateExportRoutine(sample As %Integer = 0) as %Status [ Language = objectscript ]
Generate the Export routine.

If sample is 1 then generate code that writes sample data to a local variable.

method GetExportSize(ByRef rows As %Integer) as %Status [ Language = objectscript ]
Returns the number of rows in the export table in rows.

Call this after generating an export routine.

method GetSample(ByRef rows As %Integer) as %String [ Language = objectscript ]
Exports the first rows rows to a sample variable.
method OpenExport() as %Status [ Language = objectscript ]
Prepares the start of an export.

Call this after generating an export routine.

method Reset() [ Language = objectscript ]
Reset the state of this object.

Inherited Members

Inherited Properties

Inherited Methods

Feedback