Skip to main content

%Library.SQLExImData

Class %Library.SQLExImData [ Abstract, Not ProcedureBlock, System = 3 ]

Common data used by both SQL import and export classes.

Properties​

FileName​

Property FileName As %String;

File (on server) to use for import or export."

ClassName​

Property ClassName As %String;

Class to use for import/export.

TableName​

Property TableName As %String;

Table to use for import/export.

RoutineName​

Property RoutineName As %String [ Private ];

Name of generated routine.

HasHeaders​

Property HasHeaders As %Integer [ InitialExpression = 0 ];

If true, file has column headers in first row.

Delimiter​

Property Delimiter As %String;

Delimiter character or NULL for fixed width fields.

DateFormat​

Property DateFormat As %Integer;

Format for dates (passed to $ZDT).

StringQuote​

Property StringQuote As %String;

Character used to quote strings or NULL for no quoting.

NoCheck​

Property NoCheck As %Integer [ InitialExpression = 0 ];

If true, import will insert with %NOCHECK.

ColumnNames​

Property ColumnNames As list Of %String;

Names (SQL field names) of columns.

ColumnTypes​

Property ColumnTypes As list Of %String;

Data types of columns.

  • S - String
  • N - Numeric
  • D - Date

ColumnWidths​

Property ColumnWidths As list Of %Integer;

Widths of columns for FixedWidth files.

Methods​

ResetExImData​

Method ResetExImData()

Reset the export/import data.