Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
integration:rawdata:ost:environments [2011/03/15 19:46]
els
integration:rawdata:ost:environments [2016/06/28 22:38] (current)
Line 3: Line 3:
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
  
-====== ​Adminstration: Raw Data Files ======+====== ​Integration: Raw Data Files ======
  
 ===== Omnidex Standalone Tables ===== ===== Omnidex Standalone Tables =====
Line 25: Line 25:
 === Declaring Databases for Raw Data Files === === Declaring Databases for Raw Data Files ===
  
-Databases in Omnidex are of a particular type, such as Oracle, SQL Server, MySQL or ODBC.  A database that accesses raw data file has its own type: FILE.  All tables within this database must be raw data files, though they can be a mixture of the types of raw data files supported by Omnidex.  ​+Databases in Omnidex are of a particular type, such as Oracle, SQL Server, MySQLor ODBC.  A database that accesses ​raw data file has its own type: FILE.  All tables within this database must be raw data files, though they can be a mixture of the types of raw data files supported by Omnidex.  ​
  
 <​code>​ <​code>​
Line 41: Line 41:
 In the CREATE TABLE statement, the PHYSICAL clause is used to point to the physical location of the raw data file.  This PHYSICAL clause can contain a relative path name (relative to the location of the Omnidex Environment File) such as "​dat/​states.ost",​ or an absolute path name such as "​d:/​class/​lab1/​dat/​states.ost"​. ​ Unlike fixed-length and delimited files, only one Omnidex Standalone Table can be referenced in the PHYSICAL clause, and wildcards are not allowed. ​ The PHYSICAL clause can reference [[appendix:​reference:​envvar:​home|environment variables]] using a special syntax. In the CREATE TABLE statement, the PHYSICAL clause is used to point to the physical location of the raw data file.  This PHYSICAL clause can contain a relative path name (relative to the location of the Omnidex Environment File) such as "​dat/​states.ost",​ or an absolute path name such as "​d:/​class/​lab1/​dat/​states.ost"​. ​ Unlike fixed-length and delimited files, only one Omnidex Standalone Table can be referenced in the PHYSICAL clause, and wildcards are not allowed. ​ The PHYSICAL clause can reference [[appendix:​reference:​envvar:​home|environment variables]] using a special syntax.
  
-<​code ​sql>+<​code>​
 create table          "​STATES"​ create table          "​STATES"​
  ​options ​             "​OST"​  ​options ​             "​OST"​
 
Back to top
integration/rawdata/ost/environments.txt ยท Last modified: 2016/06/28 22:38 (external edit)