04-06-2012
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
can anybody give me suggestion on this ..?
i tried google but no luck.
thanks
senthil
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How can I execute another shell script from one?
Malay (5 Replies)
Discussion started by: malaymaru
5 Replies
2. Shell Programming and Scripting
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)
Discussion started by: anju
2 Replies
3. Shell Programming and Scripting
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)
Discussion started by: sais
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: Moumou
2 Replies
5. Shell Programming and Scripting
#!\bin\sh
TEST=test.log
GREP=\usr\bin\grep
$GREP -i 'dog\|cat' ${TEST}
Why doesn't grep run at all? (10 Replies)
Discussion started by: jazzaddict
10 Replies
6. Shell Programming and Scripting
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)
Discussion started by: admc123
3 Replies
7. Shell Programming and Scripting
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)
Discussion started by: ndd
3 Replies
8. IP Networking
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)
Discussion started by: bypper
5 Replies
9. Solaris
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)
Discussion started by: chekusi
3 Replies
10. Shell Programming and Scripting
#/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)
Discussion started by: Revanth547
2 Replies
script(1) User Commands script(1)
NAME
script - make record of a terminal session
SYNOPSIS
script [-a] [filename]
DESCRIPTION
The script utility makes a record of everything printed on your screen. The record is written to filename. If no file name is given, the
record is saved in the file typescript. See WARNINGS.
The script command forks and creates a sub-shell, according to the value of $SHELL, and records the text from this session. The script ends
when the forked shell exits or when Control-d is typed.
OPTIONS
The following option is supported:
-a Appends the session record to filename, rather than overwriting it.
NOTES
script places everything that appears on the screen in filename, including prompts.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
WARNINGS
script can pose a security risk when used in directories that are writable by other users (for example, /tmp), especially when run by a
privileged user, that is, root. Be sure that typescript is not a link before running script.
SunOS 5.10 30 Jan 2004 script(1)