adding test scripts
[csql.git] / test / cache / Gateway / exp.test006n.ksh
blobfd69988470a380438d94b447cef620e055eaded5
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
10 ---------------------------------------------------------
11 lower(f4)
12 ---------------------------------------------------------
13 venkatesha
14 gopal
15 ram
16 anil
17 ganesh
19 ---------------------------------------------------------
20 upper(f4)
21 ---------------------------------------------------------
22 VENKATESHA
23 GOPAL
24 RAM
25 ANIL
26 GANESH
28 ---------------------------------------------------------
29 length(f4)
30 ---------------------------------------------------------
31 10
37 ---------------------------------------------------------
38 substr(f4, 1, 4)
39 ---------------------------------------------------------
40 venk
41 gopa
42 ram
43 anil
44 gane
46 ---------------------------------------------------------
47 lpad(f4, 10 , '*')
48 ---------------------------------------------------------
49 venkatesha
50 *****gopal
51 *******ram
52 ******anil
53 ****ganesh
55 ---------------------------------------------------------
56 rpad(f4, 10 , '*')
57 ---------------------------------------------------------
58 venkatesha
59 gopal*****
60 ram*******
61 anil******
62 ganesh****