Visit Our UNIX and Linux User Community


Issue with the script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Issue with the script
# 1  
Old 08-28-2009
Issue with the script

Code:
#!/bin/ksh
set -x
SQLSTR="LOGIN/PASSWORD"

sqlplus -s ${SQLSTR} @<<EOF 
set pagesize 0 feedback off verify off heading off echo off;
UPDATE TABLE NAME
SET VALUE = VALUE + 1
where VALUE2 = 'ABCDE';
exit;
COMMIT;
EOF

i am not able to update the column and not able to exit from sqlplus.

help !!! thanksSmilie

Last edited by DukeNuke2; 08-28-2009 at 05:49 PM.. Reason: added code tags
# 2  
Old 08-28-2009
Hi.

What is @ for? (@<< EOF)

Why do you exit before you commit (not that it should matter?)?

And what do you mean by "not able to exit from SQL*Plus?
# 3  
Old 08-28-2009
that was a typing error .

once the table is updated i'm not able to exit.

---------- Post updated at 07:07 PM ---------- Previous update was at 07:04 PM ----------

Code:
#!/bin/ksh
set -x

#### Connecting to database 
SQLSTR="loginid/pass"
sqlplus -s ${SQLSTR}<<END
set pagesize 0 feedback off verify off heading off echo off
UPDATE table
SET x_col = x_col + 1
where c_col = 'abcde';
exit;
EOF

i am not able to execute !! thanks

Last edited by DukeNuke2; 08-28-2009 at 05:49 PM..
# 4  
Old 08-28-2009
I'm a bit confused now. Execute or exit? You mentioned both.

Quote:
once the table is updated i'm not able to exit
For exit can you say from what you want to exit? The SQL*Plus will exit at the closing EOF, so I'm not sure what you mean.

(I presume <<END is another typing mistake. Please use CODE-TAGS and cut and paste your code if possible).

Quote:
i am not able to execute
Not able to execute what? You said "once the record is updated..." so I presume the script itself is executable.
# 5  
Old 08-28-2009
I hope you realize this will show a process in your process table showing the username and password of the user you use to connect to the database

# ps -ef

<some uid> <some pid> <some ppid> .............. sqlplus -s <username>/<password>

Better use something like:

sqlplus -s /nolog<<END
connect ${SQLSTR}
etc
# 6  
Old 08-28-2009
If you started your 'here statement' with 'END' you should probably end it with 'END'.
Otherwise, begin and end it with 'EOF':

Code:
      RESULT=`sqlplus -s "${USER}/${PASS}@${DB}" <<EOF > mysql.log
      WHENEVER SQLERROR EXIT 1;
      SET ECHO OFF NEWPAGE 0 SPACE 0 PAGESIZE 0 FEED OFF HEAD OFF
      UPDATE table
         SET x_col = x_col + 1
       WHERE c_col = 'abcde'
      ;
      EXIT
EOF`

rc=$?
if [[ $rc -ne 0 ]]; then
   echo "Update failed"
   exit $rc
fi

# 7  
Old 08-28-2009
Quote:
Originally Posted by giannicello
If you started your 'here statement' with 'END' you should probably end it with 'END'.
Otherwise, begin and end it with 'EOF':

Code:
      RESULT=`sqlplus -s "${USER}/${PASS}@${DB}" <<EOF > mysql.log
      WHENEVER SQLERROR EXIT 1;
      SET ECHO OFF NEWPAGE 0 SPACE 0 PAGESIZE 0 FEED OFF HEAD OFF
      UPDATE table
         SET x_col = x_col + 1
       WHERE c_col = 'abcde'
      ;
      EXIT
EOF`
 
rc=$?
if [[ $rc -ne 0 ]]; then
   echo "Update failed"
   exit $rc
fi

Please try to follow the entire post before contributing.

Previous Thread | Next Thread
Test Your Knowledge in Computers #82
Difficulty: Easy
DOS was based on Unix.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Issue with pwd for script run by double click on script (MacOS High SIerra)

Hello, I have the following script that just archives and clears some log files. #!/bin/bash # script: archive_logs_and_clear # add date to logfile names and copy archive directory # clear logs # change to script directory cd ... (4 Replies)
Discussion started by: LMHmedchem
4 Replies

2. Shell Programming and Scripting

Issue with script

Hi, I am running below script using autosys. Though the script is running fine, it fails the workflow but the autosys job shows success. Can you please let me know where can i make change to script:- #!/bin/ksh #to test mail from directory set -x frequency=$1 param_file=/local/test... (4 Replies)
Discussion started by: rajrishi990
4 Replies

3. Shell Programming and Scripting

Issue in Script

I developed a script to group by 1st column and sum few of the column which are required, but while executing sum of 2nd column which has decimals in place is not getting correct sum. below is the script awk -F, '{a+=$2;b+=$33;c+=$58;d+=$11;e+=$50;}END{for(i in a)printf... (2 Replies)
Discussion started by: rramkrishnas
2 Replies

4. Shell Programming and Scripting

Issue with the script

I am trying to run a script which ftp the files from one server to another. Below is the script - #!/bin/bash echo "Please enter no : " read variable echo "You entered: $input_variable" host=xxxxx USER=xxx PASSWORD=xxx ftp -inv $HOST <<EOF user $USER $PASSWORD cd... (4 Replies)
Discussion started by: chandraprakash
4 Replies

5. Shell Programming and Scripting

Issue with script

Hi, I have a script which when i run in manually it runs properly, but when i run the same script using UC4 scheduler it dose not run properly. Below is the code i am using. i am not sure what is happening when i run this through UC4 the files are not generated. but when i run this manually it... (1 Reply)
Discussion started by: Mohammed_Tabish
1 Replies

6. Shell Programming and Scripting

Script issue

Hi Folks, I am going through a sample script which is not working. Also i want to understand the certain syntaxes #!/bin/sh clear x="y" echo "enter ur 1st no." read n1 echo "enter ur 2nd no." read n2 while do clear echo "1.sum" echo "2.subtraction" echo "3.product"... (3 Replies)
Discussion started by: rafa_fed2
3 Replies

7. Shell Programming and Scripting

What is issue with this script?

#!/bin/ksh i=1 while do j=0 while do echo "$i" j =`expr $j + 1` done i=`expr $i + 1` done (19 Replies)
Discussion started by: targetshell
19 Replies

8. Shell Programming and Scripting

Script Issue

#!/bin/bash ########################################### ADMIN="usera@mblonline.com" AMQ="userb@mblonline.com" SUBJECT="Remote Shutdown Client Status" MAIL="/bin/mail" ########################################### DAT=`date '+%d-%b-%Y'` PLUGIN="/usr/lib/nagios/plugins/check_nrpe" PORT="5666"... (2 Replies)
Discussion started by: telnor
2 Replies

9. Shell Programming and Scripting

Script running from another script issue

Hello All, I am ruuning the below script. userchecking.sh ########################### #! /bin/ksh NIS_SCRIPT_HOME="/mot/systems/NIS_SCRIPT_NEW" . $NIS_SCRIPT_HOME/common.env WORK_DIR="/mot/systems/scripts/" #WORK_DIR="/mot/b36376/myscripts/nis_user_automation"... (1 Reply)
Discussion started by: ajaincv
1 Replies

10. Shell Programming and Scripting

Bash script: issue changing directories in script

I am working on a script that checks two arguments at the command line. The first argument is a search pattern, the second can be a file or a directory, if it is a file a second script is called that checks it for the search pattern. If the second argument is a directory, it checks for the search... (5 Replies)
Discussion started by: Breakology
5 Replies

Featured Tech Videos