%Library.SQLExImData

abstract class %Library.SQLExImData

Common data used by both SQL import and export classes.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
11 1

Summary

Properties
ClassName ColumnNames ColumnTypes ColumnWidths DateFormat
Delimiter FileName HasHeaders NoCheck StringQuote
TableName
Methods
ResetExImData
Subclasses
%Library.SQLExportMgr %Library.SQLImportMgr

Properties

property ClassName as %String;
Class to use for import/export.
property ColumnNames as list of %String;
Names (SQL field names) of columns.
property ColumnTypes as list of %String;
Data types of columns.

  • S - String
  • N - Numeric
  • D - Date
property ColumnWidths as list of %Integer;
Widths of columns for FixedWidth files.
property DateFormat as %Integer;
Format for dates (passed to $ZDT).
property Delimiter as %String;
Delimiter character or NULL for fixed width fields.
property FileName as %String;
File (on server) to use for import or export."
property HasHeaders as %Integer [ InitialExpression = 0 ];
If true, file has column headers in first row.
property NoCheck as %Integer [ InitialExpression = 0 ];
If true, import will insert with %NOCHECK.
property StringQuote as %String;
Character used to quote strings or NULL for no quoting.
property TableName as %String;
Table to use for import/export.

Methods

method ResetExImData()
Reset the export/import data.
Copyright © 1997-2020 InterSystems Corporation, Cambridge, MA