This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
dev:sql:statements:create_environment:home [2010/07/02 21:38] tdo |
dev:sql:statements:create_environment:home [2010/07/03 16:30] tdo |
||
---|---|---|---|
Line 104: | Line 104: | ||
in "sales.xml"; | in "sales.xml"; | ||
</code> | </code> | ||
- | ==== IN "filename" ==== | + | ==== IN "env_filespec" ==== |
The IN clause is required and specifies the location of the physical XML Environment File. The IN clause must be specified after all other clauses except the WITH clause. | The IN clause is required and specifies the location of the physical XML Environment File. The IN clause must be specified after all other clauses except the WITH clause. | ||
- | //Filename// can also include either an absolute or relative path. When using a relative file path , it will be relative to the current working directory for the program that is being run. Typically in a production environment, absolute paths are used. When using Omnidex's Network Services and the OdxNet process, absolute paths should always be used. | + | //Env_filespec// can be either an absolute or relative path. When using a relative file path , it will be relative to the current working directory for the program that is being run. Typically in a production environment, absolute paths are used. When using Omnidex's Network Services and the OdxNet process, absolute paths should always be used. |
- | The //filename// must be enclosed within double quotes. | + | The //env_filespec// must be enclosed within double quotes. |
<code> | <code> | ||
Line 139: | Line 139: | ||
CREATE ENVIRONMENT IN "C:\data\daily_trans.xml"; | CREATE ENVIRONMENT IN "C:\data\daily_trans.xml"; | ||
</code> | </code> | ||
- | ==== WITH DELETE option ==== | ||
- | CREATE ENVIRONMENT IN "C:\data\daily_trans.xml" WITH DELETE; | + | |
==== With All Clauses ==== | ==== With All Clauses ==== | ||
<code> | <code> |