This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
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, |