From cf87940ad81e02d0fdb49936c25317499ee244ae Mon Sep 17 00:00:00 2001 From: kishoramballi Date: Mon, 30 Jun 2008 13:13:32 +0000 Subject: [PATCH] expected output files --- test/cache/Gateway/exp.test005.ksh | 63 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 63 insertions(+) create mode 100644 test/cache/Gateway/exp.test005.ksh diff --git a/test/cache/Gateway/exp.test005.ksh b/test/cache/Gateway/exp.test005.ksh new file mode 100644 index 00000000..fd699884 --- /dev/null +++ b/test/cache/Gateway/exp.test005.ksh @@ -0,0 +1,63 @@ +--------------------------------------------------------- + f1 f2 f3 f4 f5 f6 f7 f8 f9 +--------------------------------------------------------- + 1 2011 111111111 venkatesha 113.140999 111111111.111111 1915/12/25 11:42:35.0 1971/12/25 11:42:35.0 + 2 1978 222222222 gopal 114.567001 222222222.222222 1926/5/16 12:32:14.0 1972/5/16 12:32:14.0 + 3 2008 333333333 ram 122.699997 333333333.333333 1937/8/15 13:45:36.0 1973/8/15 13:45:36.0 + 4 1973 444444444 anil 142.718002 444444444.444444 1946/12/25 14:42:35.0 1974/12/25 14:42:35.0 + 5 2005 555555555 ganesh 152.718002 555555555.555555 1955/12/25 15:42:35.0 1975/12/25 15:42:35.0 + +--------------------------------------------------------- + lower(f4) +--------------------------------------------------------- + venkatesha + gopal + ram + anil + ganesh + +--------------------------------------------------------- + upper(f4) +--------------------------------------------------------- + VENKATESHA + GOPAL + RAM + ANIL + GANESH + +--------------------------------------------------------- + length(f4) +--------------------------------------------------------- + 10 + 5 + 3 + 4 + 6 + +--------------------------------------------------------- + substr(f4, 1, 4) +--------------------------------------------------------- + venk + gopa + ram + anil + gane + +--------------------------------------------------------- + lpad(f4, 10 , '*') +--------------------------------------------------------- + venkatesha + *****gopal + *******ram + ******anil + ****ganesh + +--------------------------------------------------------- + rpad(f4, 10 , '*') +--------------------------------------------------------- + venkatesha + gopal***** + ram******* + anil****** + ganesh**** + -- 2.11.4.GIT