test/sqlgw/Parameter/exp.test001.ksh

   1 noOfParamField Returns=10
   2
   3 ***********************************************
   4 0 FIELD INFORMATION ::
   5 Field Name :f1
   6 Data type of the field :0
   7 length of the field :4
   8 Offset :0
   9 Default value :
  10 Null field :0
  11 Default value :0
  12 ***********************************************
  13
  14 ***********************************************
  15 1 FIELD INFORMATION ::
  16 Field Name :f2
  17 Data type of the field :3
  18 length of the field :4
  19 Offset :0
  20 Default value :
  21 Null field :0
  22 Default value :0
  23 ***********************************************
  24
  25 ***********************************************
  26 2 FIELD INFORMATION ::
  27 Field Name :f3
  28 Data type of the field :30
  29 length of the field :32
  30 Offset :0
  31 Default value :
  32 Null field :0
  33 Default value :0
  34 ***********************************************
  35
  36 ***********************************************
  37 3 FIELD INFORMATION ::
  38 Field Name :f4
  39 Data type of the field :11
  40 length of the field :4
  41 Offset :0
  42 Default value :
  43 Null field :0
  44 Default value :0
  45 ***********************************************
  46
  47 ***********************************************
  48 4 FIELD INFORMATION ::
  49 Field Name :f5
  50 Data type of the field :11
  51 length of the field :4
  52 Offset :0
  53 Default value :
  54 Null field :0
  55 Default value :0
  56 ***********************************************
  57
  58 ***********************************************
  59 5 FIELD INFORMATION ::
  60 Field Name :f6
  61 Data type of the field :20
  62 length of the field :4
  63 Offset :0
  64 Default value :
  65 Null field :0
  66 Default value :0
  67 ***********************************************
  68
  69 ***********************************************
  70 6 FIELD INFORMATION ::
  71 Field Name :f7
  72 Data type of the field :21
  73 length of the field :4
  74 Offset :0
  75 Default value :
  76 Null field :0
  77 Default value :0
  78 ***********************************************
  79
  80 ***********************************************
  81 7 FIELD INFORMATION ::
  82 Field Name :f8
  83 Data type of the field :22
  84 length of the field :8
  85 Offset :0
  86 Default value :
  87 Null field :0
  88 Default value :0
  89 ***********************************************
  90
  91 ***********************************************
  92 8 FIELD INFORMATION ::
  93 Field Name :f9
  94 Data type of the field :0
  95 length of the field :4
  96 Offset :0
  97 Default value :
  98 Null field :0
  99 Default value :0
 100 ***********************************************
 101
 102 ***********************************************
 103 9 FIELD INFORMATION ::
 104 Field Name :f10
 105 Data type of the field :2
 106 length of the field :8
 107 Offset :0
 108 Default value :
 109 Null field :0
 110 Default value :0
 111 ***********************************************
 112 Total rows inserted 10
 113 f1=0 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 114 f1=1 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 115 f1=2 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 116 f1=3 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 117 f1=4 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 118 f1=5 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 119 f1=6 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 120 f1=7 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 121 f1=8 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 122 f1=9 | f2=10 | f3=jitendra | f4=5.500000 | f5=10.500000 | DATE=2007-1-21 | TIME=12:29:30 | TIMESTAMP=2007-1-21 12:29:30 | f9=20 | f10=12000
 123 Total row fetched=10