Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Execution problem in shell script while insert into DB
Operating Systems Solaris Execution problem in shell script while insert into DB Post 302619917 by senkerth on Friday 6th of April 2012 11:01:10 AM
Old 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

execution of shell script

How can I execute another shell script from one? Malay (5 Replies)
Discussion started by: malaymaru
5 Replies

2. Shell Programming and Scripting

problem with shell script execution

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

problem with remote execution of script using telnet

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

parallel execution of script/ synchro problem

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

Execution problem with grep script (2 variables)

#!\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

Execution problem with shell script

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

Execution problem with csh script

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

Problem with script execution from a DHCP event

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

Script on Solaris spawning 2 processes for one shell script execution

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

Execution problem with shell script for modifying a user

#/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

LEARN ABOUT DEBIAN

glfrontface

GLFRONTFACE(3G) 						  [FIXME: manual]						   GLFRONTFACE(3G)

NAME

       glFrontFace - define front- and back-facing polygons

C SPECIFICATION

       void glFrontFace(GLenum mode);

PARAMETERS

       mode
	   Specifies the orientation of front-facing polygons.	GL_CW and GL_CCW are accepted. The initial value is GL_CCW.

DESCRIPTION

       In a scene composed entirely of opaque closed surfaces, back-facing polygons are never visible. Eliminating these invisible polygons has
       the obvious benefit of speeding up the rendering of the image. To enable and disable elimination of back-facing polygons, call glEnable()
       and glDisable() with argument GL_CULL_FACE.

       The projection of a polygon to window coordinates is said to have clockwise winding if an imaginary object following the path from its
       first vertex, its second vertex, and so on, to its last vertex, and finally back to its first vertex, moves in a clockwise direction about
       the interior of the polygon. The polygon's winding is said to be counterclockwise if the imaginary object following the same path moves in
       a counterclockwise direction about the interior of the polygon.	glFrontFace specifies whether polygons with clockwise winding in window
       coordinates, or counterclockwise winding in window coordinates, are taken to be front-facing. Passing GL_CCW to mode selects
       counterclockwise polygons as front-facing; GL_CW selects clockwise polygons as front-facing. By default, counterclockwise polygons are
       taken to be front-facing.

ERRORS

       GL_INVALID_ENUM is generated if mode is not an accepted value.

ASSOCIATED GETS

       glGet() with argument GL_FRONT_FACE

SEE ALSO

       glCullFace(),

COPYRIGHT

       Copyright (C) 1991-2006 Silicon Graphics, Inc. This document is licensed under the SGI Free Software B License. For details, see
       http://oss.sgi.com/projects/FreeB/.

[FIXME: source] 						    05/30/2012							   GLFRONTFACE(3G)
All times are GMT -4. The time now is 01:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy