Shell Programming and Scripting

Hello,

I have written a script in a previous server and its being migrated to a new server. I'm trying to debug my script since i've had to make minor changes to it to get it to work.

I'm having a hard time getting my totals to populate
here is the syntax

DUMP_COUNT=`sqlplus -S $ORA_USER/$ORA_PASSWORD@$ORA_SID << END
635 SET HEADING OFF
636 SELECT COUNT(*) FROM TMP_GLEN_ALL
637 WHERE TAC_NAME = '${TAC_NAME}'
638 /
639 END`
640 DUMP_COUNT=DUMP_COUNT+0

It previously came showed
Mail on dump: 26094

now its coming out as
Mail on dump: DUMP_COUNT+0

can anyone figure this one out?

Hi
If your issue is with DUMP_COUNT, it should be

Code:

let DUMP_COUNT=DUMP_COUNT+0

Guru.

Thanks Guru for your response
One of the things I should have mentioned is that this new server doesn't let me use "let" statements. When I did it would show blank. So originally I had a let Dump_count but took out the "let"

Hi
You can use it in this way then;

Code:

DUMP_COUNT=`expr $DUMP_COUNT + 0`

In fact, you have many other way to get the same: different ways of arithmetic operations

Guru.

thanks for the help.

what worked is the $((DUMP_COUNT+0))

Thanks GURU