This shows you the differences between two versions of the page.
Next revision Both sides next revision | |||
integration:rawdata:fixed:environments [2011/03/14 14:21] 127.0.0.1 external edit |
integration:rawdata:fixed:environments [2011/03/15 19:45] els |
||
---|---|---|---|
Line 34: | Line 34: | ||
=== Declaring Tables for Fixed-length Files === | === Declaring Tables for Fixed-length Files === | ||
- | 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|environment variables]] using a 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 sql> |