* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

~~NOTOC~~ {{page>:top_add&nofooter&noeditbtn}} ====== Integration: Raw Data Files ====== ===== Delimited Files ===== [[integration:rawdata:delimited:home|Overview]] | [[integration:rawdata:delimited:environments|Environments]] | [[integration:rawdata:delimited:options|Options]] | [[integration:rawdata:delimited:datatypes|Datatypes]] | [[integration:rawdata:delimited:ofx|Offset Indexes]] | [[integration:rawdata:delimited:export|Exporting]] | **[[integration:rawdata:delimited:limitations|Limitations]]** | [[integration:rawdata:delimited:example|Example]] ---- ==== Limitations of Delimited Files ==== Delimited files are often the most portable and flexible data file to be used, but they do have some limitations. These limitations are described below: * **Datatypes** - Delimited files can store nearly every datatype supported by Omnidex, including proprietary datatypes such as ORACLE DATETIME or ODBC DATETIME. An exception to this is the relational datatypes, VARCHAR and CLOB. These datatypes cannot be represented in delimited files because they require separate storage for length and NULL indicators. For delimited files, the STRING and CHARACTER datatypes should be used instead. * **NULLs** - Delimited files are not capable of differentiating a NULL column as is done in relational databases. Omnidex will treat empty fields as NULL fields to compensate for this. For character-class datatypes, an IS NULL test will qualify any row containing an empty space in that column. For binary-class datatypes, an IS NULL test will qualify any row containing a zero in that column. * **Deletes and Updates** - Omnidex supports INSERT statements against delimited files, but it cannot support the UPDATE or DELETE statement. If UPDATE or DELETE statements are required, consider using [[admin:features:ost:home|Omnidex Standalone Tables]]. * **Data Conversions** - Delimited files store all data in character format, including binary data such as integers, floating point data, and dates. These conversions add overhead to the parsing of the data. Files with a large number of binary fields can achieve better performance using fixed-length files or [[admin:features:ost:home|Omnidex Standalone Tables]] * **Security** - Delimited files are not encrypted as they might be in a relational database. Care should be taken with file system security to properly protect the data. Despite these limitations, delimited files provide a fast, flexible, and portable solution that brings performance and ease to an application. ===== ===== **[[integration:rawdata:delimited:export|Prev]]** | **[[integration:rawdata:delimited:example|Next]]** ====== Additional Resources ====== See also: {{page>:integration:rawdata:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

Back to top
integration/rawdata/delimited/limitations.txt ยท Last modified: 2016/06/28 22:38 (external edit)
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0