test/tools/copystmt/exp.test001.ksh

   1 echo create table t1(f1 int,f2 char(20));
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 Statement Executed: Rows Affected = 1
  12 Statement Executed: Rows Affected = 1
  13 echo create table ct1 as select * from t1;
  14 Statement Executed
  15 echo create table ct2 as select * from t1 where f1 < 6;
  16 Statement Executed
  17 echo create table ct3 as select f2 from t1;
  18 Statement Executed
  19 echo create table ct4 as select f2 from t1 where f1 >3 and f1 <8;
  20 Statement Executed
  21 CREATE TABLE t1 (f1 INT , f2 CHAR (20));
  22 CREATE TABLE ct1 (f1 INT , f2 CHAR (20));
  23 CREATE TABLE ct2 (f1 INT , f2 CHAR (20));
  24 CREATE TABLE ct3 (f2 CHAR (20));
  25 CREATE TABLE ct4 (f2 CHAR (20));
  26 INSERT INTO t1 VALUES(1, 'CSQL1');
  27 INSERT INTO t1 VALUES(2, 'CSQL2');
  28 INSERT INTO t1 VALUES(3, 'CSQL3');
  29 INSERT INTO t1 VALUES(4, 'CSQL4');
  30 INSERT INTO t1 VALUES(5, 'CSQL5');
  31 INSERT INTO t1 VALUES(6, 'CSQL6');
  32 INSERT INTO t1 VALUES(7, 'CSQL7');
  33 INSERT INTO t1 VALUES(8, 'CSQL8');
  34 INSERT INTO t1 VALUES(9, 'CSQL9');
  35 INSERT INTO t1 VALUES(10, 'CSQL10');
  36 INSERT INTO ct1 VALUES(1, 'CSQL1');
  37 INSERT INTO ct1 VALUES(2, 'CSQL2');
  38 INSERT INTO ct1 VALUES(3, 'CSQL3');
  39 INSERT INTO ct1 VALUES(4, 'CSQL4');
  40 INSERT INTO ct1 VALUES(5, 'CSQL5');
  41 INSERT INTO ct1 VALUES(6, 'CSQL6');
  42 INSERT INTO ct1 VALUES(7, 'CSQL7');
  43 INSERT INTO ct1 VALUES(8, 'CSQL8');
  44 INSERT INTO ct1 VALUES(9, 'CSQL9');
  45 INSERT INTO ct1 VALUES(10, 'CSQL10');
  46 INSERT INTO ct2 VALUES(1, 'CSQL1');
  47 INSERT INTO ct2 VALUES(2, 'CSQL2');
  48 INSERT INTO ct2 VALUES(3, 'CSQL3');
  49 INSERT INTO ct2 VALUES(4, 'CSQL4');
  50 INSERT INTO ct2 VALUES(5, 'CSQL5');
  51 INSERT INTO ct3 VALUES( 'CSQL1');
  52 INSERT INTO ct3 VALUES( 'CSQL2');
  53 INSERT INTO ct3 VALUES( 'CSQL3');
  54 INSERT INTO ct3 VALUES( 'CSQL4');
  55 INSERT INTO ct3 VALUES( 'CSQL5');
  56 INSERT INTO ct3 VALUES( 'CSQL6');
  57 INSERT INTO ct3 VALUES( 'CSQL7');
  58 INSERT INTO ct3 VALUES( 'CSQL8');
  59 INSERT INTO ct3 VALUES( 'CSQL9');
  60 INSERT INTO ct3 VALUES( 'CSQL10');
  61 INSERT INTO ct4 VALUES( 'CSQL4');
  62 INSERT INTO ct4 VALUES( 'CSQL5');
  63 INSERT INTO ct4 VALUES( 'CSQL6');
  64 INSERT INTO ct4 VALUES( 'CSQL7');
  65 Statement Executed
  66 Statement Executed
  67 Statement Executed
  68 Statement Executed
  69 Statement Executed
  70 passed