Shell Programming and Scripting

Hello All

i have input files contains 2 values as following
20-Oct-09 Z59408009
20-Oct-09 Z59423060

and i am using the following script

cat /home/or/input.txt | awk '{print $2}' >log
count=0
while read line; do
count=$(( count + 1 ))
echo "UPDATE SAT_JRLTRT SET AVT='X' WHERE IDTTRX='$line' AND DATDDE=to_date('$line2','DD/MM/YYYY');" >>log1
done < log


but i need to add the above 2 values 20-Oct-09 Z59423060 and the script add one value only

any idea how it could be done

regards

Code:

while read DATE STRING; do
echo "UPDATE SAT_JRLTRT SET AVT='X' WHERE IDTTRX='$STRING' AND DATDDE=to_date('$DATE','DD/MM/YYYY');" >>log1
done < /home/or/input.txt

Thanks for help

but i dont wants machine date , i need the date in the file ?

regards

That is the date in the file.

Code:

while read DATE STRING; do
...
done < /home/or/input.txt

In any case the date in your file ('DD-MMM-YYYY') doesn't match the pattern in you update ('DD/MM/YYYY')

i am sorry i thought it was machine date ,, it works fine as i can see

---------- Post updated at 04:50 PM ---------- Previous update was at 04:49 PM ----------


man thanks man it workssssssss

what if i have another string ?

Then

Code:

while read DATE STRING; do

becomes

Code:

while read DATE STRING ANOTHER_STRING; do

man i realy apricate your deep help many thank