1 #!/bin/ksh
2
3
4  function(){
5
6
7
8
9  some scripts
10
11         //sqlldr path id/pw control=controlfile.ctl log=logfile.log>>processfile.log
12
13
14
15  }
16
17 function(){
18        some scripts 
19  }
20
21
22 function(){
23 some scripts
24  }
25
26
27
28
29  for file in path/path/path/*.xls ; do
30
31
32  loaderfilename=$file
33  controlnum=${loaderfilename##*/}
34
36  echo $controlnum
37 export controlipfile=$controlnum
38 tableNum=$(echo $controlipfile | sed 's/^[^-]*-\([^.]*\).*/\1/')
39 echo $tableNum
40 sed 's/fileName/'$controlipfile'/' mastercontrol.ctl > temp.ctl
41 cat temp.ctl | sed -e "s/ipfile/\"${controlipfile}\"/g"  > controlfile.ctl
42
43 some scripts logic related to function ()
44
45 done