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