New upstream version 4.0.2upstream/4.0.2

9 files changed, 112 insertions, 0 deletions

diff --git a/sql/del.sql b/sql/del.sql
new file mode 100755
index 0000000..d8699cc
--- /dev/null
+++ b/sql/del.sql
@@ -0,0 +1,9 @@
+# HELP;
+
+USE /opt/1Tdata/xbase/xbase.30/data;
+
+DROP TABLE IF EXISTS TestSqlM.DBF;
+
+
+
+
diff --git a/sql/oneNdxTag.sql b/sql/oneNdxTag.sql
new file mode 100755
index 0000000..71ff217
--- /dev/null
+++ b/sql/oneNdxTag.sql
@@ -0,0 +1,18 @@
+# HELP;
+
+# where the tables live
+USE /mnt/1Tdata/xbase/xbase.35/data;
+
+
+DROP TABLE IF EXISTS OneNdxTg.DBF;
+
+CREATE TABLE OneNdxTg.DBF( CHRFLD CHAR(50), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4)  LGFLD LOGICAL ); 
+
+CREATE INDEX OneNdxTg.NDX ON OneNdxTg.DBF( CHRFLD ) ASSOCIATE;
+
+INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('AAA' );
+INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('BBB' );
+INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('CCC' );
+INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('aaa' );
+INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('bbb' );
+INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('ccc' );
\ No newline at end of file
diff --git a/sql/testc.sql b/sql/testc.sql
new file mode 100755
index 0000000..85d9f18
--- /dev/null
+++ b/sql/testc.sql
@@ -0,0 +1,13 @@
+# HELP;
+
+USE /opt/1Tdata/xbase/xbase.30/data;
+
+# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y');
+
+DROP TABLE IF EXISTS TestSql.DBF;
+CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL); 
+CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE;
+
+# DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF;
+
+
diff --git a/sql/testd.sql b/sql/testd.sql
new file mode 100755
index 0000000..3bac01c
--- /dev/null
+++ b/sql/testd.sql
@@ -0,0 +1,12 @@
+# HELP;
+
+USE /opt/1Tdata/xbase/xbase.30/data;
+
+# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y');
+
+# CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL ); 
+# CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE;
+
+DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF;
+
+
diff --git a/sql/testdd.sql b/sql/testdd.sql
new file mode 100755
index 0000000..85c8000
--- /dev/null
+++ b/sql/testdd.sql
@@ -0,0 +1,14 @@
+HELP;
+
+USE /opt/1Tdata/xbase/xbase.30/data;
+
+# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y');
+
+# CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL ); 
+# CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE;
+
+#DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF;
+
+DROP TABLE IF EXISTS TestSql.DBF;
+
+
diff --git a/sql/testflg.sql b/sql/testflg.sql
new file mode 100755
index 0000000..2d00290
--- /dev/null
+++ b/sql/testflg.sql
@@ -0,0 +1,12 @@
+# HELP;
+
+USE /opt/1Tdata/xbase/xbase.30/data;
+
+DROP TABLE IF EXISTS TestFlag.DBF;
+
+CREATE TABLE TestFlag.DBF( C1 CHAR(1), C2 CHAR(2), C3 CHAR(3), D1 DATE, D2 DATE, D3 DATE, I1 INTEGER, I2 INTEGER, I3 INTEGER, N1 NUMERIC(9,1), N2 NUMERIC(9,2), N3 NUMERIC(9,3)); 
+
+# CREATE INDEX TestSql2 ON TestSql2.DBF( CHRFLD );
+
+
+
diff --git a/sql/testmdx.sql b/sql/testmdx.sql
new file mode 100755
index 0000000..859334b
--- /dev/null
+++ b/sql/testmdx.sql
@@ -0,0 +1,12 @@
+# HELP;
+
+USE /opt/1Tdata/xbase/xbase.30/data;
+
+DROP TABLE IF EXISTS TestSqlM.DBF;
+
+CREATE TABLE TestSqlM.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4)  LGFLD LOGICAL ); 
+
+# CREATE INDEX TestSqlM ON TestSqlM.DBF( CHRFLD );
+
+
+
diff --git a/sql/testmdx2.sql b/sql/testmdx2.sql
new file mode 100755
index 0000000..040dddd
--- /dev/null
+++ b/sql/testmdx2.sql
@@ -0,0 +1,12 @@
+# HELP;
+
+USE /opt/1Tdata/xbase/xbase.30/data;
+
+DROP TABLE IF EXISTS TestSql2.DBF;
+
+CREATE TABLE TestSql2.DBF( CHRFLD CHAR(100), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4)  LGFLD LOGICAL ); 
+
+CREATE INDEX Ctag1 ON TestSql2.DBF( CHRFLD );
+
+
+
diff --git a/sql/twotags.sql b/sql/twotags.sql
new file mode 100755
index 0000000..6840709
--- /dev/null
+++ b/sql/twotags.sql
@@ -0,0 +1,10 @@
+# HELP;
+
+USE /opt/1Tdata/xbase/xbase.30/data;
+
+DROP TABLE IF EXISTS TwoTags.DBF;
+
+CREATE TABLE TwoTags.DBF( CHRFLD1 CHAR(100), CHRFLD2 CHAR(100), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4)  LGFLD LOGICAL ); 
+
+
+