Hi guys my while do loop is not working properly;
As soon as the load_date and run_date is same it should stop can somebody tell me where I am having the problem?
In an oracle table I have
LOAD_DT=5/1/2009 DATE datatype
RUN_DT=5/5/2009 DATE datatype
Now in a script with a spool file I get the dates in char type
v_LOAD_DT==`head -n1 $spool | awk '{print $1}'`(20090501)
v_RUN_DT==`head -n1 $spool | awk '{print $1}'`(20090505)
while [$v_LAST_LOAD_DT -lt $v_RUN_DT]
do
#{Here I am incrementing the date]
sqlplus /nolog @increment.SQL $calc_spool
if [$? -ne 0]; then exit 1; fi
v_next_dt=`head -n1 $calc_spool | awk '{print $1}'`
echo "$v_NEXT_DT"
[$v_NEXT_DT -eq $v_RUN_DT]
#[Here I am updating the table with the next day ]
sqlplus /nolog @Update_dt.SQL $v_update
if [$? -ne 0]; then exit 1; fi
done
The problem with the syntax is the loop is not stopping. when the load_dt=run_dt the loop should stop.
But when I force it to stop I see the load_dt to be a much later date.I dont think the while do syntax is right.
And it seems it is not recognising [$v_NEXT_DT -eq $v_RUN_DT] syntax.
Can you tell me what is the problem?
Thanks in advance