Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [%SYS] >  [%Library] >  [SQLExImData]
Private  Storage   

abstract class %Library.SQLExImData

Common data used by both SQL import and export classes.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
12 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 (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.