Shell Programming and Scripting

The way you set it up, it's not less than 245, so this should hardly be surprising. It's also not clear under what circumstances you could expect the same number to be less than 245 and greater than 355 at the same time. What do you want it to do, exactly?

you can't increment the variable in this way..
use

Thanks vidyadar for pointing out that..

Era,
Thanks tats the mistake on my part..
it should be

while [ "$prev_Ixref" -gt "245" -a "$prev_Ixref" -lt "355" ]
like this..
thanks for that..
currently i am having a problem in network..once its done.. i ll let u knw the results..

Thanks once again..

guys, the script ran successfully guys,,
no i ll start to build my actual requirements on it..
guys actually i have to update a column..
the column is a number which is auto generated..

Lets say the column is currently having 245,
then i have to update it with 355..

so in the place of echo.. i am goin to write this code..

db2 -v "update tablename set column_name = $prev_Ixref \
where column_name= $curr_Ixref "

can u please help me out with this..

then why are you checking for greater and less than??
and that update statement should work.. you can write full update statement in single line..
i have les idea about db2 sorry ..

vidayadhar,, am talkin abt updating 8 crore records, which i cant do it in a single go,,
so i have to do it only 5 lakh records at a time..
i will do a commit after that and repeat the update query again..

Anyway thanks vidayadar

yes ofcourse you can update any no of rows..
but as you said
i din't get how this condition is satisfied by your script??