test/sqlapi/Csql/DDLStmt/exp.test007n.ksh

   1 Connection opened
   2 Table t1 Created
   3 Hash Index Created on TINYINT field f1
   4 Hash Index Created on SMALLINT field f2
   5 Hash Index Created on INT field f3
   6 Hash Index Created on BIGINT field f4
   7 Hash Index Created on CHAR field f5
   8 Hash Index Created on VARCHAR field f6
   9 Hash Index Created on DATE field f9
  10 Hash Index Created on TIME field f10
  11          TABLES
  12         --------
  13         t1
  14 Connection Closed
  15 Usage: catalog [-u username] [-p passwd] [-l] [-i] [-d] [-T table] [-I index] [-D <lock|trans|proc|chunk>]
  16        l -> list all table with field information
  17             list all Index information
  18        i -> reinitialize catalog tables. Drops all tables.
  19        d -> print db usage statistics
  20        T -> list table information
  21        I -> list index information
  22        D -> print debug information for system tables
  23 Note: If multiple options are specified, last one will be considered.
  24 echo drop table t1;
  25 Statement Executed