|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Issue with the script
Post 302348447 by karthicss on Friday 28th of August 2009 09:21:13 AM
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;
EOFhelp !!! thanks
Last edited by DukeNuke2; 08-28-2009 at 05:49 PM.. Reason: added code tags
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
#!/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
4. Shell Programming and Scripting
#!/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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
gpe-question
GPE-QUESTION(1) gpe-question GPE-QUESTION(1) NAME
gpe-question - GPE interface for asking questions from shell scripts. SYNOPSIS
gpe-question [---icon] name {--question "Question text"} {--buttons icon1:text1} [icon2:text2 ...] DESCRIPTION
This manual page was written for the Debian(TM) distribution because the original program does not have a manual page. gpe-question provides dialogues to raise a question within the GPE Palmtop Environment with cancel and ok buttons. OPTIONS
--question STRING The question to ask the user via the dialogue. --buttons type:label The type and label of the button(s) to be shown. Repeat for additional buttons. EXAMPLES
gpe-question "test" --question "Do you want to check first?" --buttons YES:yes NO:no AUTHOR
This manual page was written by Neil Williams <codehelp@debian.org> for the Debian(TM) system (but may be used by others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by the Free Software Foundation. On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL. AUTHOR
Moray Allen Author. COPYRIGHT
Copyright (C) 2007 Neil Williams Debian 1 January 16, 2007 GPE-QUESTION(1)