interface_file_ff.sh[99]: syntax error at line 1 : `)' unexpected


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting interface_file_ff.sh[99]: syntax error at line 1 : `)' unexpected
# 1  
Old 07-07-2008
interface_file_ff.sh[99]: syntax error at line 1 : `)' unexpected

Hi,
I tried to execute the following code but it showed the output

mobile number : 35353425
corr plan id : 13-may-2008
corr target : 551
active_dt : 23414
no ident : IDD
action name: A
To get the subscriber number for the given mobile number and check if it is active and not suspended
interface_file_ff.sh[99]: syntax error at line 1 : `)' unexpected .


Please help me as I am not able to find out what is wrong with the code and the reason for the syntax error. The other detauils are read perfectly from the file and echoed onto the screen. Line number 99 is ${ORACLE_HOME}/bin/sqlplus ${DBCU} <<-EOF > /dev/null.


#! /usr/bin/ksh

LOGDATE=`date +%Y%m%d%H%M%S`
export LOGDATE

LOGFILE=${HOME}/utilities/COLLECTIONS/log/interface_file_ff_${LOGDATE}.log
export LOGFILE

rm -f ${LOGFILE}
touch ${LOGFILE}

echo "`date`: <BEGIN> Log Started for interface_file_ff.sh" >> ${LOGFILE}

#Get the Database User Name and Password
DBCU=`grep DBCU ${HOME}/utilities/COLLECTIONS/config/exec_details|cut -f2 -d"="`
export DBCU

if test -f ${HOME}/utilities/COLLECTIONS/data/interface_file_ff_test.dat
then
for line in `cat ${HOME}/utilities/COLLECTIONS/data/interface_file_ff_test.dat`
do
mobile_no=`echo ${line}|cut -f1 -d","`
export mobile_no

corr_plan_id=`echo ${line}|cut -f2 -d","`
export corr_plan_id

corr_target=`echo ${line}|cut -f3 -d","`
export corr_target

active_dt=`echo ${line}|cut -f4 -d","`
export active_dt

no_identifier=`echo ${line}|cut -f5 -d","`
export no_identifier

action_name=`echo ${line}|cut -f6 -d","`
export action_name


echo "mobile number : ${mobile_no}"
echo "corr plan id : ${corr_plan_id}"
echo "corr target : ${corr_target}"
echo "active_dt : ${active_dt}"
echo "no ident : ${no_identifier}"
echo "action name: ${action_name}"
done

else
echo "File not found ">>${LOGFILE}
echo "File not found"
exit 1
fi

echo " To get the subscriber number for the given mobile number and check if it is active and not suspended"
${ORACLE_HOME}/bin/sqlplus ${DBCU} <<-EOF > /dev/null
set feed off
set head off
set trimspool on
spool ${HOME}/utilities/COLLECTIONS/log/${LOGFILE}_${SYS_DATE}_temp.log
select subscr_no from cust_map where extid = ${mobile_no};
spool off;
EOF
# 2  
Old 07-07-2008
Try echoing the values of DBCU and ORACLE_HOME before the sqlplus line, maybe they aren't being set correctly.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Sh: -c: line 0: syntax error near unexpected token `(' how to resolve this

Below query is not working for me. Please help me on this DATA EXCLUDE STATEMENT: TABLE:\"LIKE \'%\_HISTORY\'\", TABLE:\"LIKE \'%\_HIST\'\", TABLE:\"in \(select tname from tab where REGEXP_LIKE(TNAME,\'\_H$\'\))\", TABLE:\"LIKE \'%\_LOG\'\", TABLE:\"LIKE \'DW\_%\'\", TABLE:\"LIKE... (1 Reply)
Discussion started by: princy
1 Replies

2. Shell Programming and Scripting

Syntax error at line 24: `(' unexpected

Hi, I am getting an wired error.... the script is running fine when i run it manually... but the same when i try to run in nohup mode, i am getting error if Error: syntax error at line 24: `(' unexpected The above if is the 24th line!!! I dont understand the error... (4 Replies)
Discussion started by: Nithz
4 Replies

3. Shell Programming and Scripting

Syntax error at line 14: `gw_user=' unexpected

Masters, i iam writing a script (dont have much experience in the process of learning) which handles file copy to multiple servers and users for deployment purpose. Below is the snippet. When ever i run i get syntax error but it works fine on another machine. Please help me out. if then... (10 Replies)
Discussion started by: ameyrk
10 Replies

4. Shell Programming and Scripting

line 15: syntax error: unexpected end of file

Hi all, I am very new to programming and even newer to this forum as well, so I apologize if this should have been in the Newbie category, but... I am currently trying to figure out Shell Scripting and am running into problems early. Not having taken any kind of programming class, I am not even... (2 Replies)
Discussion started by: ccorder22
2 Replies

5. UNIX for Dummies Questions & Answers

syntax error at line 8: `(' unexpected

Hi I am having a shell script load_data.sh which calls /home/users/project/.profile. When am executing the script, am getting below error: $sh -x bin/load_data.sh null + . /home/users/project/.profile bin/load_data.sh: syntax error at line 8: `(' unexpected The line which is throwing... (1 Reply)
Discussion started by: brijesh.dixit
1 Replies

6. Shell Programming and Scripting

syntax error at line 28: `(' unexpected

hi can anyone pls look into this....shell script... Pls find the error below: > sh -n tmp tmp: syntax error at line 28: `(' unexpected isql -Usa -S$1 -P`grep $1 dbpassword|cut -d ":" -f3` -w2000 -b<<! set nocount on declare @i int declare @dbname char(6) declare @tmp int if... (10 Replies)
Discussion started by: rajashekar.y
10 Replies

7. UNIX Desktop Questions & Answers

line 3: syntax error near unexpected token `('

Hi All I've used UNIX in the past experimenting with commands through terminal but thats about it. Im now currently teaching myself "C". Using a book from the library, the first chapter asks you run and compile your program from a command-line prompt. As you will see the program is very simple,... (4 Replies)
Discussion started by: camzio
4 Replies

8. Solaris

syntax error at line 59: `end of file' unexpected

Hello... I'm trying to run the sshd script, but I keep geting the Syntax errot message . Here's the last few lines on the script. set nu in vi shows 58 lines, but I keep getting error referring to line 59. Any help is appreciated. Thanks, Remi else echo... (4 Replies)
Discussion started by: Remi
4 Replies

9. UNIX for Dummies Questions & Answers

syntax error at line 33: `elif` unexpected

#!/bin/sh echo "Choose option: e, d, l, t, p, or x." read option if test $option = e then echo "Filename?" read file if test ! -f $file then echo "No such file" else echo "Yes its a file" fi ... (4 Replies)
Discussion started by: hazy
4 Replies

10. Programming

sh: syntax error at line 1: `>' unexpected

I compiled C program under SUN OS sparcv9 ...I had a problem related to SIGBUS which has been resolved by adding an option to the CC compiler which is memory alignement option ..-memalign=1i as I remmber ...after running the program I got the below error please let me KNow more details what should... (2 Replies)
Discussion started by: atiato
2 Replies
Login or Register to Ask a Question