diff options
Diffstat (limited to 'sql/testflg.sql')
-rwxr-xr-x | sql/testflg.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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 ); + + + |