https://www.omnidex.com/docs/v51/ 2026-04-23T08:51:04+0000 https://www.omnidex.com/docs/v51/ https://www.omnidex.com/docs/v51/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:46:19+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=tutorials:home&rev=1351262779&do=diff Tutorials * Simple DDL for flat file environment. * Creating a very simple flat file Environment and doing retrievals. * Writing a simple JDBC program to access the simple flatfile Environment. text/html 2012-10-26T14:46:19+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=tutorials:simple_ddl&rev=1351262779&do=diff Create a simple functioning Environment with an Omnidex index os> odxsql > CREATE ENVIRONMENT IN "myenv.xml"; > CREATE DATABASE mydb TYPE FLATFILE IN "myenv.xml"; > CREATE TABLE mytable PHYSICAL "test1" (myseq integer, mytext char(60) quicktext ) IN "myenv.xml"; > CONNECT myenv.xml; > UPDATE INDEXES; > SELECT * FROM mytable where mytext = '<some criteria>'; > DISCONNECT; > EXIT os> text/html 2012-10-26T14:46:19+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=tutorials:simple_flatfile&rev=1351262779&do=diff Simple Flat File Step 1 - Creating the Omnidex Environment Source DDL Omnidex uses the SQL Standard Data Definition Statement (DDL) for defining the Omnidex metadata used to connect to a data store. The following sample Environment Catalog Source is the minimum set of statements that will compile into an Omnidex Compiled Environment. text/html 2012-10-26T14:46:19+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=tutorials:simple_flatfile_java_jdbc&rev=1351262779&do=diff Simple Java program using JDBC to access an Omnidex Environment Step 1 - Create the JAVA program to test JDBC Connect /** Java Program to test a connection to the Omnidex * JDBC driver. * Make sure OdxNet is running * Create a JDBC Datasource file with DSEDIT. * Make sure there is a path setting to the Omnidex bin directory. */ import java.io.*; import java.sql.*; public class OdxTestConnection { static public void main(String args[]) { Connection odxconnection = null; try …