Class Reference
Cache for UNIX 2018.1.3
InterSystems: The power behind what matters   
Documentation  Search
Private  Storage  

abstract class %Library.SQLExImData

Common data used by both SQL import and export classes.


Parameters Properties Methods Queries Indices ForeignKeys Triggers
12 1


ClassName ColumnNames ColumnTypes ColumnWidths DateFormat
Delimiter FileName HasHeaders NoCheck StringQuote


%Library.SQLExportMgr %Library.SQLImportMgr


• 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.


• method ResetExImData()
Reset the export/import data.

Copyright © 1997-2020, InterSystems Corporation