summaryrefslogtreecommitdiff
path: root/sql/testc.sql
diff options
context:
space:
mode:
authorJörg Frings-Fürst <debian@jff-webhosting.net>2022-12-07 13:17:14 +0100
committerJörg Frings-Fürst <debian@jff-webhosting.net>2022-12-07 13:17:14 +0100
commit4875a3dd9b183dcd2256e2abfc4ccf7484c233b4 (patch)
tree0abbea881ded030851014ffdd60fbf71fead8f65 /sql/testc.sql
parentdaf17154bf13139d9375f48525d19d6aaba08155 (diff)
New upstream version 4.0.2upstream/4.0.2
Diffstat (limited to 'sql/testc.sql')
-rwxr-xr-xsql/testc.sql13
1 files changed, 13 insertions, 0 deletions
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;
+
+