Search Results

./script.sh param1 param2 param3 .... paramN
in script.sh

parameters=$*

for param in $parameters
do
echo $param
done

PASS=Figomom#0;export PASS is password that is getting used to connect to database. Once you set the password you need to export it as environment variable. So whenever you need you can use it.

if...

have you added the first line to tell which shell you are running? like
#!/bin/sh

better write a SQL script which will have all steps to shutdown DB. Pass your necessary information as argument to script and execute it from ksh file in silent mode.
like -


inside ksh file...

try it this way.
capture the process id of sub process and keep checking for completion in a loop after some interval.

wrapper.ksh
########################
#!/bin/ksh

nohup ./pii_insert.ksh...

total_rec=`wc -l $file`
#subtract 1 for header record
total_rec=`expr $total_rec - 1`
#put the header record first in output file
head -1 $file > somefile
#sort based on first filed except...

echo "Jennifer Jones (student) \"id:376765748587/7465674775\" NewYork"|cut -d"\"" -f2

newstr=`echo "part=gfjhwhedaqh=ghdgwg^*^(G=="|cut -d"=" -f2-`

try to put variable in double quotes -

stringtocheck=("$line")
echo "$stringtocheck"

If you want to calculate percentage by using one expression, use -

echo "Percentage% =" `expr \( \( 8500 - 8000 \) \* 100 \) / 2000`"%"

first put the contents of file in a temp file with trimming the space then try to search the pattern, words will be separated by max 1 space.


cat file_name|tr -s " " >temp_file

it will come like that only because is has space between that field. either separate that file with valid separator or use double quotes for the last field.

another way you can do is -

store...

i=0
i=`expr $i + 1`


don't use blank space while assigning some value to a variable.