test/jdbc/Parameters/exp.test001.ksh

   1 SELECT * FROM T1;
   2
   3 Tuple value is 2008-03-21 0 Nihar0
   4 Tuple value is 2009-11-10 1 Nihar1
   5 Tuple value is 2008-03-24 2 Nihar2
   6 Tuple value is 2009-11-10 3 Nihar3
   7 Tuple value is 2008-03-21 4 Nihar4
   8 Tuple value is 2009-11-10 5 Nihar5
   9
  10 SELECT * FROM T1 where f1 = '2009-11-10';
  11
  12 Tuple value is 2009-11-10 1 Nihar1
  13 Tuple value is 2009-11-10 3 Nihar3
  14 Tuple value is 2009-11-10 5 Nihar5
  15
  16 SELECT * FROM T1 where f2 >= ? and f3 <= ?;
  17
  18 Tuple value is 2009-11-10 1 Nihar1
  19 Tuple value is 2008-03-24 2 Nihar2
  20 Tuple value is 2009-11-10 3 Nihar3
  21
  22 SELECT * FROM T1 where f1='2009-11-10' and f2 >= ? and f3 <= ?;
  23
  24 Tuple value is 2009-11-10 1 Nihar1
  25 Tuple value is 2009-11-10 3 Nihar3