Skip to main content

%Library.SQLExImData

abstract class %Library.SQLExImData

Common data used by both SQL import and export classes.

Property Inventory

Method Inventory

Properties

property ClassName as %String;
Class to use for import/export.
Property methods: ClassNameDisplayToLogical(), ClassNameGet(), ClassNameIsValid(), ClassNameLogicalToDisplay(), ClassNameLogicalToOdbc(), ClassNameNormalize(), ClassNameSet()
property ColumnNames as list of %String;
Names (SQL field names) of columns.
Property methods: ColumnNamesBuildValueArray(), ColumnNamesCollectionToDisplay(), ColumnNamesCollectionToOdbc(), ColumnNamesDisplayToCollection(), ColumnNamesDisplayToLogical(), ColumnNamesGet(), ColumnNamesGetObject(), ColumnNamesGetObjectId(), ColumnNamesGetSwizzled(), ColumnNamesIsValid(), ColumnNamesLogicalToDisplay(), ColumnNamesLogicalToOdbc(), ColumnNamesNormalize(), ColumnNamesOdbcToCollection(), ColumnNamesSet(), ColumnNamesSetObject(), ColumnNamesSetObjectId()
property ColumnTypes as list of %String;
Data types of columns.

  • S - String
  • N - Numeric
  • D - Date
Property methods: ColumnTypesBuildValueArray(), ColumnTypesCollectionToDisplay(), ColumnTypesCollectionToOdbc(), ColumnTypesDisplayToCollection(), ColumnTypesDisplayToLogical(), ColumnTypesGet(), ColumnTypesGetObject(), ColumnTypesGetObjectId(), ColumnTypesGetSwizzled(), ColumnTypesIsValid(), ColumnTypesLogicalToDisplay(), ColumnTypesLogicalToOdbc(), ColumnTypesNormalize(), ColumnTypesOdbcToCollection(), ColumnTypesSet(), ColumnTypesSetObject(), ColumnTypesSetObjectId()
property ColumnWidths as list of %Integer;
Widths of columns for FixedWidth files.
Property methods: ColumnWidthsBuildValueArray(), ColumnWidthsCollectionToDisplay(), ColumnWidthsCollectionToOdbc(), ColumnWidthsDisplayToCollection(), ColumnWidthsDisplayToLogical(), ColumnWidthsGet(), ColumnWidthsGetObject(), ColumnWidthsGetObjectId(), ColumnWidthsGetSwizzled(), ColumnWidthsIsValid(), ColumnWidthsLogicalToDisplay(), ColumnWidthsNormalize(), ColumnWidthsOdbcToCollection(), ColumnWidthsSet(), ColumnWidthsSetObject(), ColumnWidthsSetObjectId()
property DateFormat as %Integer;
Format for dates (passed to $ZDT).
Property methods: DateFormatDisplayToLogical(), DateFormatGet(), DateFormatIsValid(), DateFormatLogicalToDisplay(), DateFormatNormalize(), DateFormatSet()
property Delimiter as %String;
Delimiter character or NULL for fixed width fields.
Property methods: DelimiterDisplayToLogical(), DelimiterGet(), DelimiterIsValid(), DelimiterLogicalToDisplay(), DelimiterLogicalToOdbc(), DelimiterNormalize(), DelimiterSet()
property FileName as %String;
File (on server) to use for import or export."
Property methods: FileNameDisplayToLogical(), FileNameGet(), FileNameIsValid(), FileNameLogicalToDisplay(), FileNameLogicalToOdbc(), FileNameNormalize(), FileNameSet()
property HasHeaders as %Integer [ InitialExpression = 0 ];
If true, file has column headers in first row.
Property methods: HasHeadersDisplayToLogical(), HasHeadersGet(), HasHeadersIsValid(), HasHeadersLogicalToDisplay(), HasHeadersNormalize(), HasHeadersSet()
property NoCheck as %Integer [ InitialExpression = 0 ];
If true, import will insert with %NOCHECK.
Property methods: NoCheckDisplayToLogical(), NoCheckGet(), NoCheckIsValid(), NoCheckLogicalToDisplay(), NoCheckNormalize(), NoCheckSet()
property StringQuote as %String;
Character used to quote strings or NULL for no quoting.
Property methods: StringQuoteDisplayToLogical(), StringQuoteGet(), StringQuoteIsValid(), StringQuoteLogicalToDisplay(), StringQuoteLogicalToOdbc(), StringQuoteNormalize(), StringQuoteSet()
property TableName as %String;
Table to use for import/export.
Property methods: TableNameDisplayToLogical(), TableNameGet(), TableNameIsValid(), TableNameLogicalToDisplay(), TableNameLogicalToOdbc(), TableNameNormalize(), TableNameSet()

Methods

method ResetExImData()
Reset the export/import data.

Subclasses

FeedbackOpens in a new tab