Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Can anyone find the mistake in this script file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Can anyone find the mistake in this script file
# 1  
Old 10-12-2011
Question Can anyone find the mistake in this script file
Code:
#!/bin/ksh
db_user=`echo $DB_USER_NAME`
db_pwd=`echo $DB_PASSWORD`
db_sid=`echo $TWO_TASK`
sqlplus -s $db_user/$db_pwd@$db_sid << EOF
a = select   ACK_PARTY_NAME,bus_event_seq_nbr  from bus_event where  ack_party_name like 'MOVE_USAGE_DAEMON%'  and bus_event_seq_nbr='3969094'
set -- echo $a | sed 's,[aA-zZ]*,,1'
Run -i $1 -e $2
EOF

SmilieSmilieSmilie
Last edited by pludi; 10-12-2011 at 05:48 AM..
# 2  
Old 10-12-2011
It would be helpful if you could also tell us what error you're getting, or what doesn't work as expected and what you're expecting.
# 3  
Old 10-12-2011
What error are you getting?
# 4  
Old 10-12-2011
Question
The error am getting while executing the script is lyk this :

Code:
SP2-0158: unknown SET option "--"
  1* = select   ACK_PARTY_NAME,bus_event_seq_nbr  from bus_event where  ack_party_name like 'MOVE_USAGE_DAEMON%'  and bus_event_seq_nbr='3969094'
= select   ACK_PARTY_NAME,bus_event_seq_nbr  from bus_event where  ack_party_name like 'MOVE_USAGE_DAEMON%'  and bus_event_seq_nbr='3969094'
*
ERROR at line 1:
ORA-24374: define not done before fetch or execute and fetch

Last edited by pludi; 10-12-2011 at 06:09 AM..
# 5  
Old 10-12-2011
change your sed with like below and re-try
Code:
sed 's,[Aa-zZ]*,,1'

# 6  
Old 10-12-2011
Might be the below one will help you ..
Code:
a=`sqlplus -s $db_user/$db_pwd@$db_sid << EOF
select   ACK_PARTY_NAME,bus_event_seq_nbr  from bus_event where  ack_party_name like 'MOVE_USAGE_DAEMON%'  and bus_event_seq_nbr='3969094';
EOF`
echo $a | sed 's,[aA-zZ]*,,1'

This User Gave Thanks to jayan_jay For This Post:
rkrish
# 7  
Old 10-12-2011
Question
Quote:
Originally Posted by ygemici
change your sed with like below and re-try
Code:
sed 's,[Aa-zZ]*,,1'



Again the same error mentioned above...no change in error description..:-(

---------- Post updated at 04:05 AM ---------- Previous update was at 03:57 AM ----------

Quote:
Originally Posted by jayan_jay
Might be the below one will help you ..
Code:
a=`sqlplus -s $db_user/$db_pwd@$db_sid << EOF
select   ACK_PARTY_NAME,bus_event_seq_nbr  from bus_event where  ack_party_name like 'MOVE_USAGE_DAEMON%'  and bus_event_seq_nbr='3969094';
EOF`
echo $a | sed 's,[aA-zZ]*,,1'


I ran with the changes you have mentioned but the arguments are passing as null..
The values are not passed to the command
Code:
#!/bin/ksh
db_user=`echo $DB_USER_NAME`
db_pwd=`echo $DB_PASSWORD`
db_sid=`echo $TWO_TASK`
a=`sqlplus -s $db_user/$db_pwd@$db_sid << EOF
select   ACK_PARTY_NAME,bus_event_seq_nbr  from bus_event where  ack_party_name like 'MOVE_USAGE_DAEMON%'  and bus_event_seq_nbr='3969094';
EOF`
set -- echo $a | sed 's,[aA-zZ]*,,1'
echo  Run -i $1 -e $2



o/p:

Code:
Run -i -e

Moderator's Comments:
Mod Comment Video Tutorial on how to use Code tags in the UNIX and Linux Forums
Last edited by pludi; 10-12-2011 at 06:11 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Archive script spot a mistake?

#!/bin/bash source=/to_be_archived dest=/archived echo "is this archive for an audio tar press (t) or an audio directory press (d)" read option case $option in d) cd "$source" echo "please specify full path to directory you want to be... (6 Replies)
Discussion started by: robertkwild
6 Replies

2. Shell Programming and Scripting

Perl script to read string from file#1 and find/replace in file#2

Hello Forum. I have a file called abc.sed with the following commands; s/1/one/g s/2/two/g ... I also have a second file called abc.dat and would like to substitute all occurrences of "1 with one", "2 with two", etc and create a new file called abc_new.dat sed -f abc.sed abc.dat >... (10 Replies)
Discussion started by: pchang
10 Replies

3. UNIX for Dummies Questions & Answers

Can anyone help me to spot my mistake?

Hi there can anyone help me to spot my mistake and please explain why it appears My code : #!/usr/bin/gawk -f BEGIN { bytes =0} { temp=$(grep "datafeed\.php" | cut -d" " -f8) bytes += temp} END { printf "Number of bytes: %d\n", bytes } when I am running ./q411 an411 an411: ... (6 Replies)
Discussion started by: FUTURE_EINSTEIN
6 Replies

4. Shell Programming and Scripting

Do not find the mistake in a small routine!!!

Have a textfile (regular updated) with informations about datafiles . Each line is describing a datafile. Now I am trying to delete several specific lines in this textfile, which are defined before in a kind of removal list. Can not find the mistake I have done in the script because in the... (5 Replies)
Discussion started by: jurgen
5 Replies

5. UNIX for Dummies Questions & Answers

Probably some stupid mistake...

Hi everyone ! I have a file wich look like this : >Sis01 > Sis02 ... >Sis44 I want to separe each paragraphe in a different file, so I decide to use the "FOR" loop + sed. for f in {01..44} do (5 Replies)
Discussion started by: sluvah
5 Replies

6. Shell Programming and Scripting

Is there any mistake in this code:

cat $1 | sort -n | uniq | $1 in other words, I sort the content of the file and put the ouput in the same file, is there any mistakes in this cshell code ??? (4 Replies)
Discussion started by: Takeeshe
4 Replies

7. Shell Programming and Scripting

Removing rows based on a different file (ignore my earlier post - there was a mistake).

Sorry I made a mistake in my last post (output is suppose to be the opposite). Here is a revised post. Hi, I am not sure if this has already been asked (I tried the search but the search was too broad). Basically I want to remove rows based on another file. So file1 looks like this (tab... (3 Replies)
Discussion started by: kylle345
3 Replies

8. Shell Programming and Scripting

Can't find the mistake in sed expression

Hi there, Can anyone help me find the correct expression for sed. I want to repace iface eth0 inet wathever with iface eth0 inet static Thanks for your help Santiago (5 Replies)
Discussion started by: chebarbudo
5 Replies

9. AIX

Did a Mistake with HACMP

Hi, I needed space on a FS, and when I've added the space on the filesystem, I did it trough the regular smitty fs inteface and not with smitty cl_lvm. Can someone help me to repair the situat before a faileover happen ? Thanks for your help,:mad: (13 Replies)
Discussion started by: azzed27
13 Replies

10. Shell Programming and Scripting

how to find Script file location inside script

I have to find out the file system location of the script file inside script. for example a script "abc.sh" placed anywhere in the file system when executed shold tell by itself the location of it. example #pwd / #./abc this is / #cd /root #./abc this is /root #cd / #/root/abc this... (10 Replies)
Discussion started by: asami
10 Replies
Login or Register to Ask a Question