A PCRE internal error occured. This might be caused by a faulty plugin

* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

{{page>:top_add&nofooter&noeditbtn}} ~~NOTOC~~ ====== Programs: OdxSQL ====== [[programs:odxsql:home|Overview]] | [[programs:odxsql:commands|Commands]] | [[programs:odxsql:options|Options]] | [[programs:odxsql:cmdline|Command-line]] | **[[programs:odxsql:files|Command Files]]** ---- ===== Command Files ===== OdxSQL can execute a file of commands using the USE command. This is useful to run a batch of commands in succession. A common use of this approach are the CREATE ENVIRONMENT, CREATE DATABASE and CREATE TABLE statements that are used to create an Omnidex environment file. A command file is often used to process the commands to update the rollup tables, indexes and text dictionaries for an environment. A command file can also contain a series of SELECT statements to be processed, both in test and production environments. Any OdxSQL command can be used in a command file. The only restriction is on the USE statement so that files cannot be recursively called. A command file can contain a USE statement, but that second command file cannot contain a USE statement. ==== Test Directives ==== OdxSQL supports additional test directives that can be placed in command files for testing purposes. These are special comments that OdxSQL will recognize and process accordingly. === ;<COMMON> === The COMMON directive contains statements that must be run whenever the command file is run. These commands are not a test per se, but rather essential commands that prepare for running tests. The most common statements found in the COMMON section are CONNECT, DISCONNECT and SET. === ;<SECTION=name> === The SECTION directive indicates a section of tests. It is provided for organizational purposes only. === ;<TEST=name> === The TEST directive is the most essential directive, and it starts a series of statements that must be run together. For example, some tests may require that a segment be created before it is subsequently referenced, or a row must be updated before it is retrieved. All statements between one TEST directive and the next TEST, SECTION or COMMON directive will be considered a single test. If an error occurs, though, the remaining statements in the test will not be processed. === ;<TEST_CLEANUP> === The TEST_CLEANUP directive is optionally at the end of a test and contains commands that must be processed, even if the test fails. For example, if a TEST uses a CREATE SEGMENT command, the TEST_CLEANUP will likely contain a DROP SEGMENT command. ===== ===== **[[programs:odxsql:cmdline|Prev]]** ====== Additional Resources ====== See also: {{page>:programs:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

Back to top
programs/odxsql/files.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