3 TESTFILE
=${PWD}/jdbc
/Gateway
/ConnTest01.java
7 REL_PATH
=`pwd`/jdbc
/Gateway
9 export CLASSPATH
=$CLASSPATH:${REL_PATH}
11 echo "CREATE TABLE T1 (f1 integer, f2 smallint, f3 tinyint, f4 bigint, f5 float, f6 char(10), f7 date, f8 time, f9 timestamp);" >${REL_PATH}/t1create.sql
12 isql
$DSN < ${REL_PATH}/t1create.sql
>/dev
/null
2>&1
15 rm -f ${REL_PATH}/t1create.sql
18 $CSQL_INSTALL_ROOT/bin
/cachetable
-t T1
>/dev
/null
2>&1
21 rm -f ${REL_PATH}/t1create.sql
30 $CSQL_INSTALL_ROOT/bin
/cachetable
-t T1
-u >/dev
/null
2>&1
33 rm -f ${REL_PATH}/t1create.sql
36 echo "drop table T1;">${REL_PATH}/dp.sql
37 isql
$DSN < ${REL_PATH}/dp.sql
>/dev
/null
2>&1
38 rm -f ${REL_PATH}/dp.sql
39 rm -f ${REL_PATH}/t1create.sql