Issue with using Expression inside SHELL

boopathyvasagam · #1 07-29-2010

Hi,
i tried to execute the following script. I am having a issue with the expr operator i used.

Code:

[marcdev@dyl02019dat03 eipfeed]$ vi wordcount_check.sh
        set feedback off;
        set heading off;
        set verify off;
        select count(*) from marc_bulk_status where status = 'READY_TO_PROCESS';
        exit;
        END`
echo "number of files to processed $count"
totwordc=0
while [ "$count" -gt 0 ]
do
        file_path=`sqlplus -s prospect_stg/prospect_stg@mdmpt <<ENDSQL
        set feedback off;
        set heading off;
        set verify off;
        VARIABLE g_file_path VARCHAR2(400);
        EXECUTE :g_file_path :=  fn_get_filepath();
        PRINT g_file_path;
        exit;
        ENDSQL`
echo $file_path
wordc=`wc -l $file_path`
echo "record count and the files to be processed now is $wordc"
echo $totwordc
totwordc=`expr $totwordc + $wordc`
count=`expr $count - 1`
done
echo "total records in the $count files is $totwordc"
sqlplus -s prospect_stg/prospect_stg@mdmpt <<ENDSQL
set feedback off;
set heading off;
set verify off;
update marc_bulk_status set status = 'READY_TO_PROCESS'
where   status = 'BUILD_IN_PROGRESS';
commit;
exit;
ENDSQL

methyl · #2 07-29-2010

Please post the exact and complete script (within code tags) without anything else that may have been on the screen at the time.

One potential problem is with this line, but the output posted does not match this problem:

Code:

        ENDSQL`

fpmurphy · #3 07-29-2010

Another solution which does not require the use of awk is

Code:

wordc=`wc -l < $file_path`

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Awk inside Awk expression	pepeli30	UNIX for Dummies Questions & Answers	2	12-03-2009 02:32 AM
Webalizer issue when inside script	eyes_drinker	Shell Programming and Scripting	0	01-09-2009 06:27 AM
Regular expression issue	chriss_58	Shell Programming and Scripting	4	12-03-2008 12:39 PM
Awk - Using a Shell Variable in the Reg Expression	not4google	Shell Programming and Scripting	6	11-01-2006 09:42 AM
How to run unix commands in a new shell inside a shell script?	hkapil	Shell Programming and Scripting	2	01-04-2006 05:56 AM

The Following User Says Thank You to methyl For This Useful Post:
boopathyvasagam (4 Weeks Ago)

The Following User Says Thank You to fpmurphy For This Useful Post:
boopathyvasagam (4 Weeks Ago)


	Powered by