Execution problem in shell script while insert into DB
Hi,
am facing some problem while inserting a record into a script
Please find script below.
`sqlplus -s asdf/asdf123 <<eof!
set feedback off;
set heading off;
set verify off;
insert into <table_name>(NNI,TECH_MARKER,CURRENT_FIELD_BUILD_ID,DEFAULT_FIELD_BUILD_ID,CURRENT_EMNAME,DEFAULT_EM NAME,CURRENT_CAP_OFFSET,PA
THFINDER,BB_FIRST_FLAG) values ('$nni','$TechM','$FBI','$FBI','T_Live','T_Live','6,3,5','$pathf','$bb_first');
commit;
exit
eof!`
if [ "$scen" -eq 3 ] || [ "$scen" -eq 4 ]
then
`sqlplus -s asdf/asdf123 <<eof!
set feedback off
set heading off
set verify off
insert into <table_name>(NNI,TECH_MARKER,CURRENT_FIELD_BUILD_ID,DEFAULT_FIELD_BUILD_ID,CURRENT_EMNAME,DEFAULT_EM NAME,CURRENT_CAP_OFFSET) v
alues ('32008018','$TechM','AD-XONLY-LTS-21C','AD-XONLY-LTS-21C','T_Captive','T_Captive','7,6,5');
commit;
exit
eof!`
fi
when i try to execute am facing the following problem.
makePhDN: insert: not found
makePhDN: insert: not found
To keep the forums high quality for all users, please take the time to format your posts correctly.
First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)
Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.
Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.
#/bin/sh
echo "enter the user name"
read $username
echo "Enter new home directory"
read $newhd
usermod -d $newhd $username ;;
error while executing :
enter the user name
Rev
Enter new home directory:
/home/58745
usermod: option requires an argument -- 'd'
Try `usermod --help' or... (2 Replies)
Hi,
I am having a shell script on Solaris 10 which has a while loop as shown below.
#!/usr/bin/ksh
#
while
do
sleep 60
done
Name of the shell script is coldcentric.sh. I executed script /DATAWAREHOUSE/LOAD/Scripts/coldcentric.sh from a command task in Informatica worklow as... (3 Replies)
Hi,
I'm installing a DHCPD Server with the packages from a distro SLES11 SP1 (dhcp-server-3.1.1-7.12).
And a DNS Server with PowerDNS:
pdns-recursor-3.3-1
pdns-static-3.0-1
The DHCP update de DNS Server, but PowerDNS is not RFC 2135 compliant, and I have to update the MySQL register... (5 Replies)
Hi All,
I have a small issue with my csh script which I am using to FTP a file. What I know is...there are two commands to execute script.. 'sh <file>' & '\<file>'. When I execute my script with command 'sh <file>', it gives me syntax error while it runs successfully with command '\<file>'. I am... (3 Replies)
Hi all,
I want to use perl string manipulation commands in my shell script.
I have written following script.
echo "enter name"
read name
perl -e '$m=length($name);
echo $m
it gives an error: unrecognized token in perl command line.
do not suggest me an equivalent command of shell... (3 Replies)
Hi everybody,
In a csh script, i need to run 4 time the same prog with different parameters. What i want is to run them in parallel. for this i use the command
toto1.sh & toto2.sh & toto3.sh & toto4.sh
For this I have no problem. In fact, I need to wait until all the programs are over to... (2 Replies)
Hi all,
i am trying to remotely execute a script from a different server.
this is the code that i use :
#!bin/sh
pwd
(sleep 1 echo "username"
sleep 2 echo "pwd"
sleep 2 echo "cd /path/to/file"
if
then
echo "script1.sh"
echo "mailx -s "Task Executed"... (1 Reply)
Hi All,
i am running a shell script in which there is a command
`ps -ef | grep smon > db`
When i execute this command in the command prompt i am getting the desired output..but when the script is executed..the db file is getting created but with no values...I could not find the reason for... (2 Replies)