4 # 3.create table, load with no definition option. should succeed and csqldump should display the records.
6 #Run this test only under csql/test or on this directory.
7 #Otherwise, it may fail
9 input
=${PWD}/cache
/CacheTable
/inputtest4.sql
13 REL_PATH
=${PWD}/cache
/CacheTable
16 cp $CSQL_CONFIG_FILE /tmp
/csql.conf
18 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
19 DS
="$DSN $DBUSER $PASSWORD"
20 rm -f /tmp
/csql
/csqlds.conf
21 touch /tmp
/csql
/csqlds.conf
22 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
25 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
28 echo CACHE_TABLE
=true
>>$CSQL_CONFIG_FILE
29 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
31 isql
$DS < ${REL_PATH}/inputtest4.sql
>/dev
/null
2>&1
32 if [ "$DSN" = "oracle" ]
34 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/csqlinputoracle.sql
> /dev
/null
2>&1
36 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/csqlinput.sql
> /dev
/null
2>&1
40 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
44 rm -f /tmp
/csql
/csqltable.conf
45 touch /tmp
/csql
/csqltable.conf
47 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
-s > /dev
/null
2>&1
50 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
54 rm -f /tmp
/csql
/csqltable.conf
55 touch /tmp
/csql
/csqltable.conf
57 $CSQL_INSTALL_ROOT/bin
/csqldump
60 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE
63 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop.sql
> /dev
/null
2>&1
64 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
65 rm -f /tmp
/csql
/csqltable.conf
66 touch /tmp
/csql
/csqltable.conf
67 cp /tmp
/csql.conf
$CSQL_CONFIG_FILE