Differences

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

Link to this comparison view

integration:rawdata:fixed:environments [2011/04/04 22:08]
deb
integration:rawdata:fixed:environments [2016/06/28 22:38] (current)
Line 36: Line 36:
 Tables will point to one or more fixed-length files, and the files must match the record layout specified in the [[dev:sql:statements:create_table:home|CREATE TABLE]] statement.  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.dat", or an absolute path name such as "d:/class/lab1/dat/states.dat".  This PHYSICAL clause can also contain wildcards as described below, and can also reference [[appendix:reference:envvar:home|environment variables]] using special syntax. Tables will point to one or more fixed-length files, and the files must match the record layout specified in the [[dev:sql:statements:create_table:home|CREATE TABLE]] statement.  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.dat", or an absolute path name such as "d:/class/lab1/dat/states.dat".  This PHYSICAL clause can also contain wildcards as described below, and can also reference [[appendix:reference:envvar:home|environment variables]] using special syntax.
  
-<code sql>+<code>
 create table          "STATES" create table          "STATES"
  physical             "dat/states.dat"  physical             "dat/states.dat"
Line 44: Line 44:
 In the example above, a single file was used as the source of data for a table.  It is also possible for multiple files to be used as the source of data for a table.  As long as the files all share the same record layout, they will all be processed when reading the table. Filesets can be declared as a comma-separated list of files, or they can be declared using wildcards in the filename.  In this example, three files are declared individually in the PHYSICAL clause: In the example above, a single file was used as the source of data for a table.  It is also possible for multiple files to be used as the source of data for a table.  As long as the files all share the same record layout, they will all be processed when reading the table. Filesets can be declared as a comma-separated list of files, or they can be declared using wildcards in the filename.  In this example, three files are declared individually in the PHYSICAL clause:
  
-<code sql>+<code>
 create table          "STATES" create table          "STATES"
  physical             "c:/class/lab1/dat/states1.dat,   physical             "c:/class/lab1/dat/states1.dat, 
Line 54: Line 54:
 In this second example, wildcards are used to declare these files: In this second example, wildcards are used to declare these files:
  
-<code sql>+<code>
 create table          "STATES" create table          "STATES"
  physical             "c:/class/lab1/dat/states*.dat,   physical             "c:/class/lab1/dat/states*.dat, 
 
Back to top
integration/rawdata/fixed/environments.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