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
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)
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)
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)
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)
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)
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)
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)
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)
Perl::Critic::Policy::ControlStructures::ProhibitLabelsWUserpContPerl::Critic::Policy::ControlStructures::ProhibitLabelsWithSpecialBlockNames(3pm)NAME
Perl::Critic::Policy::ControlStructures::ProhibitLabelsWithSpecialBlockNames - Don't use labels that are the same as the special block
names.
AFFILIATION
This Policy is part of the core Perl::Critic distribution.
DESCRIPTION
When using one of the special Perl blocks "BEGIN", "END", "CHECK", "INIT", and "UNITCHECK", it is easy to mistakenly add a colon to the end
of the block name. E.g.:
# a BEGIN block that gets executed at compile time.
BEGIN { <...code...> }
# an ordinary labeled block that gets executed at run time.
BEGIN: { <...code...> }
The labels "BEGIN:", "END:", etc. are probably errors. This policy prohibits the special Perl block names from being used as labels.
CONFIGURATION
This Policy is not configurable except for the standard options.
SEE ALSO
The Perl Buzz article on this issue at http://perlbuzz.com/2008/05/colons-invalidate-your-begin-and-end-blocks.html
<http://perlbuzz.com/2008/05/colons-invalidate-your-begin-and-end-blocks.html>.
ACKNOWLEDGMENT
Randy Lauen for identifying the problem.
AUTHOR
Mike O'Regan
COPYRIGHT
Copyright (c) 2008-2011 Mike O'Regan. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2Perl::Critic::Policy::ControlStructures::ProhibitLabelsWithSpecialBlockNames(3pm)