test/cache/Gateway/exp.test006n.ksh

   1 ---------------------------------------------------------
   2         f1      f2      f3      f4      f5      f6      f7      f8      f9
   3 ---------------------------------------------------------
   4         1       2011    111111111       venkatesha      113.140999      111111111.111111        1915/12/25      11:42:35.0      1971/12/25 11:42:35.0
   5         2       1978    222222222       gopal   114.567001      222222222.222222        1926/5/16       12:32:14.0      1972/5/16 12:32:14.0
   6         3       2008    333333333       ram     122.699997      333333333.333333        1937/8/15       13:45:36.0      1973/8/15 13:45:36.0
   7         4       1973    444444444       anil    142.718002      444444444.444444        1946/12/25      14:42:35.0      1974/12/25 14:42:35.0
   8         5       2005    555555555       ganesh  152.718002      555555555.555555        1955/12/25      15:42:35.0      1975/12/25 15:42:35.0
   9
  10 ---------------------------------------------------------
  11         lower(f4)
  12 ---------------------------------------------------------
  13         venkatesha
  14         gopal
  15         ram
  16         anil
  17         ganesh
  18
  19 ---------------------------------------------------------
  20         upper(f4)
  21 ---------------------------------------------------------
  22         VENKATESHA
  23         GOPAL
  24         RAM
  25         ANIL
  26         GANESH
  27
  28 ---------------------------------------------------------
  29         length(f4)
  30 ---------------------------------------------------------
  31         10
  32         5
  33         3
  34         4
  35         6
  36
  37 ---------------------------------------------------------
  38         substr(f4, 1, 4)
  39 ---------------------------------------------------------
  40         venk
  41         gopa
  42         ram
  43         anil
  44         gane
  45
  46 ---------------------------------------------------------
  47         lpad(f4, 10 , '*')
  48 ---------------------------------------------------------
  49         venkatesha
  50         *****gopal
  51         *******ram
  52         ******anil
  53         ****ganesh
  54
  55 ---------------------------------------------------------
  56         rpad(f4, 10 , '*')
  57 ---------------------------------------------------------
  58         venkatesha
  59         gopal*****
  60         ram*******
  61         anil******
  62         ganesh****
  63