adding test scripts
[csql.git] / test / cache / Gateway / exp.test005n.ksh
blobcb5c35438ffb5c56be2a8283f871041adbc659b6
1 ---------------------------------------------------------
2 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
3 ---------------------------------------------------------
4 1 2011 111111111 Govind 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 kishor 122.699997 333333333.333333 1937/8/15 13:45:36.0 1973/8/15 13:45:36.0
7 4 1973 444444444 kiran 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 6 1962 666666666 suresh 162.718002 666666666.666666 1965/12/25 16:42:35.0 1976/12/25 16:42:35.0
10 7 1965 777777777 Praba 172.718002 777777777.777777 1975/12/25 17:42:35.0 1977/12/25 17:42:35.0
11 8 1942 888888888 karan 182.718002 888888888.888888 1985/12/25 18:42:35.0 1978/12/25 18:42:35.0
12 9 1956 999999999 sharan 192.718002 999999999.999999 1995/12/25 19:42:35.0 1979/12/25 19:42:35.0
13 10 1999 101010101 vijay 102.718002 111111111.999999 1915/12/25 20:42:35.0 1980/12/25 20:42:35.0
15 ---------------------------------------------------------
16 lower(f4)
17 ---------------------------------------------------------
18 govind
19 gopal
20 kishor
21 kiran
22 ganesh
23 suresh
24 praba
25 karan
26 sharan
27 vijay
29 ---------------------------------------------------------
30 upper(f4)
31 ---------------------------------------------------------
32 GOVIND
33 GOPAL
34 KISHOR
35 KIRAN
36 GANESH
37 SURESH
38 PRABA
39 KARAN
40 SHARAN
41 VIJAY
43 ---------------------------------------------------------
44 length(f4)
45 ---------------------------------------------------------
57 ---------------------------------------------------------
58 substr(f4, 1, 4)
59 ---------------------------------------------------------
60 Govi
61 Gopa
62 kish
63 kira
64 gane
65 sure
66 Prab
67 kara
68 shar
69 vija
71 ---------------------------------------------------------
72 lpad(f4, 10 , '*')
73 ---------------------------------------------------------
74 ****Govind
75 *****Gopal
76 ****kishor
77 *****kiran
78 ****ganesh
79 ****suresh
80 *****Praba
81 *****karan
82 ****sharan
83 *****vijay
85 ---------------------------------------------------------
86 rpad(f4, 10 , '*')
87 ---------------------------------------------------------
88 Govind****
89 Gopal*****
90 kishor****
91 kiran*****
92 ganesh****
93 suresh****
94 Praba*****
95 karan*****
96 sharan****
97 vijay*****