03-23-2013
Error in UNIX script
When i run a script in linux. It shows the following error.
Code :
'icsftpagent.sh: line 114: syntax error near unexpected token `'icsftpagent.sh: line 114: `Nicsftp() The script is as follows.
Code :
#!/bin/bash
#### Copyright Notice:
####
#### Copyright (c) 2007 Network Intelligence Corporation
####
#### Warning: This computer program is protected by copyright law and
#### international treaties. Unauthorized reproduction or distribution
#### of this program, or any portion of it, may result in severe civil
#### and criminal penalties, and will be prosecuted to the maximum
#### extent possible under the law.
####
#### RSA, The Security Division of EMC - Automated FTP/SCP/SFTP Script v2.7.11
####
###################
####
#### Begin User configuration
####
##########
########
######
####
#SILENT MODE
#produce no output to the console;
#set this to true when running from cron
#to reduce emails sent to root.
SILENT=true
# Have the Solaris POSIX compliant binaries first in the path.
# The /usr/bin directory in Solaris doesn't have POSIX compliant
# binaries. This is particularly a problem for the awk command we are
# using. (ECE-138)
#PATH=/usr/xpg6/bin:/usr/xpg4/bin:/usr/css/bin:$PATH
## Enter the hostname/IP address of the enVision machine to which you want to
## send the data files
ENVISION=192.168.1.20
## Enter the directories where the data files, which you need to send, exist. Separate
## multiple directories with a colon (:). This script must have read permissions
## to the directories.
## Example for multiple folders DATA_DIRECTORY=/var/log/:/var/log/audit
DATA_DIRECTORY=/var/log/
## The directory on the enVision box where the files should be written to. This directory
## is relative to the enVision/ftp_files directory. If the directory name contains a
## space it will need to be double escaped. For example, if the directory name is
## "name with spaces", the variable needs to be set to "name\ with\ spaces".
ENVISION_DIRECTORY=Squid_192.168.1.63
## The script keeps its persistent information in a directory. The
## script must have read and write permissions to this directory.
NIC_DIRECTORY=/usr/local/nic
## TRANSFER_METHOD=SFTP/SCP/FTP
## Select the method used to transfer the files to enVision. SFTP is recommended.
## valid options are FTP, SFTP and SCP
TRANSFER_METHOD=SFTP
## Enter a username (ftp default: anonymous; SFTP/SCP default: nic_sshd)
USERNAME=nic_sshd
## Enter a password (anonymous connections accept any password)
PASSWORD=RSAlab@12345
## Enter the identity/private key file for the user specified above user
## default is $HOME/.ssh/id_rsa
IDENTITY=~/.ssh/id_rsa
## Enter the file matching specification. "*" will send any files in the directory. Separate
## multiple fielnames with a colon (:).
## Example for multiple files::
## FILESPEC=*.log:xyz.log
FILESPEC=access.log
## Enter the file extension of uploaded files
UPLOAD_SPEC=tmp
## A value of "no" leaves the file intact after the transfer has occurred.
## This should be set to "no" if you intend to manage the cleanup/archiving
## of the original log data with another process.
FLAG_REMOVE_FILE_AFTER_SEND=no
## The ftp or sftp client returns no error code if the transfer fails. We assume the client
## will return one (1) line (stating the local directory has changed). If the client
## you are using returns a different line count upon successful completion, then enter
## that number here. (You will most likely not need to change this.)
NUMBER_OF_OUTPUT_LINE_ON_SFTP_SUCCESS=6
## Enter 1 for Solaris, 3 for Red Hat
NUMBER_OF_OUTPUT_LINE_ON_FTP_SUCCESS=1
## CONFIG FILE
## Optionally define a config file that will override any settings made in this file.
## This file must be located in the $NIC_DIRECTORY folder as defined in this script.
NIC_CONFIG=nicsftpagent.conf
## Script Name. Used to make sure only one copy of the script is running.
## If this script is renamed, change this setting to match.
SCRIPT_NAME="nicsftpagent.sh"
## Number of seconds to delay before terminating a job. This should be long enough
## to allow transfer of your largest log files. The script will update its activity between
## each file copy. If another instance is launched it will kill the original if it.s been this
## many seconds since the original update in the running indicator file.
KILL_RUNNING_AFTER=300
## This script supports 2 version of tail. The script will automaticaly determin the version
## to use. To force the use of one of the versions you can change this option.
## 0 - automatic
## 1 - tail +10 file
## 2 - tail --lines=+10 file
USETAIL=0
## This script supports including the header in all log files. This feature was added
## in order to support the Oracle File System Audit log files.
## 0 - feature disabled
## 14 - header support for Oracle
USEHEAD=0
####
######
########
##########
############
############ End User configuration
############
################################################################################
################################################################################
#
# DO NOT EDIT BELOW THIS LINE
#
################################################################################
################################################################################
Nicsftp()
{
if ["x$SILENT" = "x" ]
then
echo "**** Reading new data from $d/$i"
fi
# Support for use of headers - added version 2.7.3
if [ $USEHEAD -gt 0 ]
then
head --lines $USEHEAD "$d/$i" > "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
TMPCOUNT=`expr $TMPCOUNT - $USEHEAD`
if [ "x$SILENT" = "x" ]
then
echo "**** Re-writing file header."
fi
else
if [ "x$SILENT" = "x" ]
then
echo "**** Skipping file header."
fi
fi
# Support for different version of tail
if [ "x$USETAIL" = "x0" ]
then
if [ "x$SILENT" = "x" ]
then
echo "**** Automatic tail syntax checking. You may see an error that can be ignored."
fi
tail +1 "$d/$i" >/dev/null 2>/dev/null
if [ $? -gt 0 ]
then
USETAIL=2
else
USETAIL=1
fi
if [ "x$SILENT" = "x" ]
then
echo "**** Use tail syntax $USETAIL."
fi
fi
if [ "x$USETAIL" = "x1" ]
## Conditions to check to see if file has already been read - version 2.7.3
then
if [ -f "$NIC_DIRECTORY$d/$i-nic.last.line" ]
then
tail +$LAST "$d/$i" >> "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
else
tail +$LAST "$d/$i" > "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
fi
else
if [ -f "$NIC_DIRECTORY$d/$i-nic.last.line" ]
then
tail --lines=+$LAST "$d/$i" >> "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
else
tail --lines=+$LAST "$d/$i" > "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
fi
if [ $? -gt 0 ]
then
echo "**** Critical failure when running tail"
# exit script now.
# clean up running files
rm -f "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
if [ "x$SILENT" = "x" ]
then
echo "**** removing running files"
fi
if [ -f "$NIC_DIRECTORY/running$ENVISION" ]
then
rm -f "$NIC_DIRECTORY/running$ENVISION"
fi
if [ -f "$NIC_DIRECTORY/running$ENVISION.pid" ]
then
rm -f "$NIC_DIRECTORY/running$ENVISION.pid"
fi
exit 1
fi
fi
TMPCOUNT=`wc -l "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC" | awk '{print $1}'`
## Added for version 2.7.3
if [ -f "$NIC_DIRECTORY$d/$i-nic.last.line" ]
then
TMPCOUNT=`expr $TMPCOUNT - $USEHEAD`
fi
###################################################
# No Transfer Option
###################################################
if [ "$TRANSFER_METHOD" = "xNONE" ]
then
echo "**** Generated $NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC (Transfer disabled)"
###################################################
# FTP Transfer Option
###################################################
elif [ "x$TRANSFER_METHOD" = "xFTP" ]
then
if [ "x$SILENT" = "x" ]
then
echo "**** Beginning FTP transfer of $d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
fi
ftp -n $ENVISION > "$NIC_DIRECTORY/transfer.output" 2> "$NIC_DIRECTORY/transfer.stderr" <<END1
quote USER $USERNAME
quote PASS $PASSWORD
lcd "$NIC_DIRECTORY$d"
cd "$ENVISION_DIRECTORY"
put "$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC$GZ"
quit
END1
if [ `wc -l "$NIC_DIRECTORY/transfer.output" | awk '{print $1}'` -gt $NUMBER_OF_OUTPUT_LINE_ON_FTP_SUCCESS ]
then
if [ "x$SILENT" = "x" ]
then
echo "**** There may have been errors during the transfer:("
fi
cat "$NIC_DIRECTORY/transfer.output"
TRANSFER_ERRORS=yes
fi
###################################################
# SFTP Transfer Option
###################################################
elif [ "x$TRANSFER_METHOD" = "xSFTP" ]
then
echo lcd \"$NIC_DIRECTORY$d\" > "$NIC_DIRECTORY/sftp.in"
echo cd \"$ENVISION_DIRECTORY\" >> "$NIC_DIRECTORY/sftp.in"
echo put \"$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC$GZ\" \"$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC$GZ\" >> $NIC_DIRECTORY/sftp.in
echo quit >> $NIC_DIRECTORY/sftp.in
sftp -b "$NIC_DIRECTORY/sftp.in" -oIdentityFile="$IDENTITY" $USERNAME@$ENVISION > "$NIC_DIRECTORY/transfer.output" 2> "$NIC_DIRECTORY/transfer.stderr"
if [ $? != "0" ]
then
echo "**** Error detected during transfer:"
echo ""
cat "$NIC_DIRECTORY/transfer.output"
cat "$NIC_DIRECTORY/transfer.stderr"
echo ""
TRANSFER_ERRORS=yes
fi
if [ `wc -l "$NIC_DIRECTORY/transfer.output" | awk '{print $1}'` -gt $NUMBER_OF_OUTPUT_LINE_ON_SFTP_SUCCESS ]
then
echo "**** There may have been errors during the transfer:"
echo ""
cat "$NIC_DIRECTORY/transfer.output"
cat "$NIC_DIRECTORY/transfer.stderr"
echo ""
TRANSFER_ERRORS=yes
fi
###################################################
# SCP Transfer Option
###################################################
elif [ "x$TRANSFER_METHOD" = "xSCP" ]
then
if [ "x$SILENT" = "x" ]
then
echo "**** Beginning SCP transfer of $d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
fi
/usr/bin/scp -i "$IDENTITY" "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC$GZ" $USERNAME@$ENVISION:\"$ENVISION_DIRECTORY\"/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC$GZ > "$NIC_DIRECTORY/transfer.output" 2> "$NIC_DIRECTORY/transfer.stderr"
if [ $? != "0" ]
then
if [ "x$SILENT" = "x" ]
then
echo "**** Error detected during SCP transfer:"
fi
cat "$NIC_DIRECTORY/transfer.output"
TRANSFER_ERRORS=yes
fi
else
echo "No Transfer Method Selected. ($TRANSFER_METHOD)"
TRANSFER_ERRORS=yes
fi
###################################################
# Transfer Complete
###################################################
if [ "x$SILENT" = "x" ]
then
echo "**** Removing temporary data file $i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
fi
rm -f "$NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
if [ "$TRANSFER_ERRORS" = "yes" ]
then
echo "**** Transfer Errors processing $NIC_DIRECTORY$d/$i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC"
echo "**** Exiting Script"
mv -f "$NIC_DIRECTORY/transfer.output" "$NIC_DIRECTORY/transfer.output.lasterr"
mv -f "$NIC_DIRECTORY/transfer.stderr" "$NIC_DIRECTORY/transfer.stderr.lasterr"
# clean up running files
if [ "x$SILENT" = "x" ]
then
echo "**** removing running files"
fi
if [ -f "$NIC_DIRECTORY/running$ENVISION" ]
then
rm -f "$NIC_DIRECTORY/running$ENVISION"
fi
if [ -f "$NIC_DIRECTORY/running$ENVISION.pid" ]
then
rm -f "$NIC_DIRECTORY/running$ENVISION.pid"
fi
if [ -f "$NIC_DIRECTORY/waiting$ENVISION" ]
then
rm -f "$NIC_DIRECTORY/waiting$ENVISION"
fi
exit 1
else
NEWLINE=`expr $LAST + $TMPCOUNT`
if [ "x$SILENT" = "x" ]
then
echo "**** Updating file line count previous count: $LAST new count: $NEWLINE"
fi
echo "$NEWLINE" > "$NIC_DIRECTORY$d/$i-nic.last.line"
touch "$NIC_DIRECTORY$d/$i-nic.last.time"
if [ "x$FLAG_REMOVE_FILE_AFTER_SEND" = "xyes" ]
then
if [ "x$SILENT" = "x" ]
then
echo "**** Removing Log File $i"
fi
rm -f "$i"
fi
mv -f "$NIC_DIRECTORY/transfer.output" "$NIC_DIRECTORY/transfer.output.last"
mv -f "$NIC_DIRECTORY/transfer.stderr" "$NIC_DIRECTORY/transfer.stderr.last"
fi
}
### Get config file if it exists; overrides anything set above.
if [ -f "$NIC_DIRECTORY/$NIC_CONFIG" ]
then
. "$NIC_DIRECTORY/$NIC_CONFIG"
if [ "x$SILENT" = "x" ]
then
echo "Loaded config file $NIC_DIRECTORY/$NIC_CONFIG"
fi
elif [ -f "$NIC_CONFIG" ]
then
. "$NIC_CONFIG"
if [ "x$SILENT" = "x" ]
then
echo "Loaded config file $NIC_CONFIG"
fi
fi
#################################################
# If a copy of the script is running. exit now.#
#################################################
if [ -f "$NIC_DIRECTORY/running$ENVISION" ]
then
if [ "x$SILENT" = "x" ]
then
echo "A file exists indicating an instance of the script"
echo "is already running. If the script has not updated"
echo "this file in $KILL_RUNNING_AFTER seconds, this original"
echo "process will be stopped."
fi
RUNNING=`cat "$NIC_DIRECTORY/running$ENVISION" 2>/dev/null`
#WAITING=`date +%s`
#Bug 112031
WAITING=`perl -e 'print time(),"\n"'`
DIFF=`expr $WAITING - $RUNNING`
if [ $DIFF -gt $KILL_RUNNING_AFTER ]
then
if [ "x$SILENT" = "x" ]
then
echo "The previous script has not responded in $DIFF"
echo "seconds. If it is still running we will attempt to stop it."
fi
rm -f "$NIC_DIRECTORY/running$ENVISION"
# kill the pid now.
OLDPID=`cat "$NIC_DIRECTORY/running$ENVISION.pid" 2>/dev/null`
if [ `ps -aef | grep $OLDPID | grep $SCRIPT_NAME | wc -l | awk '{print $1}'` -gt 0 ]
then
if [ "x$SILENT" = "x" ]
then
echo "This script running on PID $OLDPID is inactive and being killed."
fi
kill -9 $OLDPID
fi
else
if [ "x$SILENT" = "x" ]
then
echo "The previous instance was active $DIFF seconds ago."
echo "This instance will exit now."
fi
exit 0;
fi
fi
TIMENAME=`date +%Y%m%d%H%M%S`
#################################################
# what are we going to do
#################################################
if [ "x$SILENT" = "x" ]
then
echo "*******************************************************"
echo "**** Time: $TIMENAME"
echo "**** Data Directory(s): $DATA_DIRECTORY"
echo "**** NIC Directory: $NIC_DIRECTORY"
echo "**** enVision: $ENVISION"
echo "**** envision Directory: $ENVISION_DIRECTORY"
echo "*******************************************************"
fi
### Test that NIC directory exists
if [ ! -d "$NIC_DIRECTORY" ]
then
echo "$NIC_DIRECTORY cannot be found."
exit 1
fi
PWD=`pwd`
### Test that each of the data directories exists
for d in `echo "$DATA_DIRECTORY" | awk '{split($0, a, ":"); for (i in a) print a[i]; }'`
do
if [ ! -d $d ]
then
echo "$d cannot be found."
exit 1
elif [ -d "$NIC_DIRECTORY$d" ]
then
# Clear out old tracking files
cd "$NIC_DIRECTORY$d"
if [ "x$SILENT" = "x" ]
then
echo "Checking for old tracking files in $NIC_DIRECTORY$d"
fi
#for j in `ls *-nic.* | awk 'BEGIN{FS="-nic"} {print $1}'`
#ls *-nic.* | while read j
find . -name "*-nic.*" -type f -print | awk 'BEGIN{FS="/"} {print $2}' | while read j
do
PASTFILETEMP=`echo $j | awk 'BEGIN{FS="-nic"} {print $1}'`
if [ ! -f "$d/$PASTFILETEMP" ]
then
if [ "x$SILENT" = "x" ]
then
echo "remove $NIC_DIRECTORY$d/$PASTFILETEMP-nic.last.line"
fi
rm -f "$NIC_DIRECTORY$d/$PASTFILETEMP-nic.last.line"
fi
done
fi
done
DIRCOUNT=0
for d in `echo "$DATA_DIRECTORY" | awk '{split($0, a, ":"); for (i in a) print a[i]; }'`
do
DIRCOUNT=`expr $DIRCOUNT + 1`
cd "$d"
mkdir -p "$NIC_DIRECTORY$d"
if [ "x$SILENT" = "x" ]
then
echo "**** Scanning directory $d..."
fi
for i in `echo "$FILESPEC" | awk '{split($0, a, ":"); for (k in a) print a[k]; }'` #Array has been added to $FILESPEC to support multiple filenames for multiple folders
#ls $FILESPEC | while read i
#find . -name "$FILESPEC" -type f -print | awk 'BEGIN{FS="/"} {print $2}' | while read i
do
if [ "x$SILENT" = "x" ]
then
echo "**** Processing $i..."
fi
# running date
#date +%s > "$NIC_DIRECTORY/running$ENVISION"
#Bug 112031
THEDATE=`perl -e 'print time(),"\n"'`
echo $THEDATE > "$NIC_DIRECTORY/running$ENVISION"
# running pid
echo $$ > "$NIC_DIRECTORY/running$ENVISION.pid"
#
if [ -f "$i" ]
then
TRANSFER_ERRORS=no
TIMESTAMP=`date +%Y%m%d%H%M%S`
LAST=1
if [ -f "$NIC_DIRECTORY$d/$i-nic.last.line" ]
then
LAST=`cat "$NIC_DIRECTORY$d/$i-nic.last.line" 2>/dev/null`
fi
WC=`wc -l "$i" | awk '{print $1}'`
WC=`expr $WC + 1`
if [ $WC -lt $LAST ]
then
LAST=1
if [ "x$SILENT" = "x" ]
then
echo "**** WARNING: file was shorter than expected. Reading from the beginning."
echo "**** Log file will be processed from line $LAST to $WC."
fi
fi
if [ $WC -eq $LAST ]
then
if [ -f "$NIC_DIRECTORY$d/$i-nic.last.time" ]
then
if [ $NIC_DIRECTORY$d/$i-nic.last.time -ot $i ]
then
LAST=1
if [ "x$SILENT" = "x" ]
then
echo "**** File $i timestamp has changed. Reading from the beginning"
echo "**** Log file will be processed from line $LAST to $WC."
fi
Nicsftp
else
#Fix bug 25079
if [ "x$FLAG_REMOVE_FILE_AFTER_SEND" = "xyes" ]
then
if [ "x$SILENT" = "x" ]
then
echo "**** Removing Log File $i"
fi
rm -f "$i"
fi
#
fi
else
if [ "x$SILENT" = "x" ]
then
echo "**** No new data in $i."
TMPCOUNT=0
fi
fi
else
#Fix bug ECE-165
if [ -f "$NIC_DIRECTORY$d/$i-nic.last.time" ]
then
if [ $NIC_DIRECTORY$d/$i-nic.last.time -ot $i ]
then
if [ "x$FLAG_REMOVE_FILE_AFTER_SEND" = "xyes" ]
then
# Start from the beginning
LAST=1
if [ "x$SILENT" = "x" ]
then
echo "**** File $i timestamp has changed. Reading from the beginning"
echo "**** Log file will be processed from line $LAST to $WC."
fi
fi
fi
else
LAST=1
fi
#End Fix
Nicsftp
fi
if [ "x$SILENT" = "x" ]
then
echo "**** Done processing file $d/$i ($i-nic.$TIMESTAMP-$DIRCOUNT.$UPLOAD_SPEC Sent $TMPCOUNT Lines)"
fi
fi
done
if [ "x$SILENT" = "x" ]
then
echo "**** Done processing directory $d"
fi
done
cd "$PWD"
# clean up running files
if [ "x$SILENT" = "x" ]
then
echo "**** removing running files"
fi
if [ -f "$NIC_DIRECTORY/running$ENVISION" ]
then
rm -f "$NIC_DIRECTORY/running$ENVISION"
fi
if [ -f "$NIC_DIRECTORY/running$ENVISION.pid" ]
then
rm -f "$NIC_DIRECTORY/running$ENVISION.pid"
fi
if [ "x$SILENT" = "x" ]
then
echo "**** Script Completed."
fi
Last edited by Franklin52; 03-23-2013 at 10:56 AM ..
Reason: Code tags
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi ,
I tried running a PL/SQL script through unix shell script.
But am getting the following error.
"Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus "
Kindly suggest.
Regards,
Samit (5 Replies)
Discussion started by: dharmesht
5 Replies
2. UNIX for Dummies Questions & Answers
how can i make one script fail if some condition is not satisfied.i m writing if ..else logic in script.i need some standard command to do that ,, (1 Reply)
Discussion started by: dr46014
1 Replies
3. Shell Programming and Scripting
Hi!
Following is the script to find the number of users and the total space consumed by them in the directory
But I am getting few errors Pls help me
data=`ls -lt $1 |tr -t |tr -s '\t'|cut -f3,5`
count=0
flag=1
sum=0
users_flag=1
check=0
declare -a users
for a in $data
do (5 Replies)
Discussion started by: joyrules
5 Replies
4. Shell Programming and Scripting
I am trying to run a unix script in my home directory.Snippet below
echo "`date '+%Y%m%d_%H%M%S'` Getting ProductList.dat"
if ( -f $DIR/ProductList.dat) then
cp $DIR/ProductList.dat MigratedProductList.dat
else
echo "`date '+%Y%m%d_%H%M%S'`ProductList.dat does not exist; Processing... (4 Replies)
Discussion started by: Mary James
4 Replies
5. Shell Programming and Scripting
When i run a script in linux. It shows the following error.
'icsftpagent.sh: line 114: syntax error near unexpected token `
'icsftpagent.sh: line 114: `Nicsftp()
My Script is as follows:
#!/bin/bash
#### Copyright Notice:
####
#### Copyright (c) 2007 Network Intelligence Corporation ... (1 Reply)
Discussion started by: sourabh.chhabra
1 Replies
6. Shell Programming and Scripting
Hello All,
I'm working on one Unix shell sript that will actually extract a column data from Oracle table using sqlplus and writes onto a file. I'm getting this error when executing the shell script:
rpt.ksh: ^JScott: not found
Below is the code in the shell script:
`sqlplus -s... (1 Reply)
Discussion started by: venkat_reddy
1 Replies
7. Shell Programming and Scripting
Hello Everyone,
Coming again for your help to solve the below error:
In a script, i had created a temp table (Temp_table) and loaded the data in it using bcp command (performed successfully) and I wanted to move it to the preferred table (called Main_table) for further use. hence I have added... (1 Reply)
Discussion started by: Suresh
1 Replies
8. UNIX for Advanced & Expert Users
Hello Everyone,
Coming again for your help to solve the below error:
In a script, i had created a temp table (Temp_table) and loaded the data in it using bcp command (performed successfully) and I wanted to move it to the preferred table (called Main_table) for further use. hence I have added... (7 Replies)
Discussion started by: Suresh
7 Replies
9. UNIX for Beginners Questions & Answers
Greeting!!
I wrote the below script to e-mail me only file names in a specific directory when a file is delayed for some time in a that directory. I am getting unexpected eof error message.
I don't want any email if the folder is blank.(if the condition is not met) I am not getting the email at... (4 Replies)
Discussion started by: Hope
4 Replies
10. UNIX for Beginners Questions & Answers
I have this UNIX script code with a query to export sql table in Oracle and export to csv file. The code gets the data correctly. However, when I run the script second time, I got the error message "not spooling currently" and shows the older data in csv file. When I delete the csv file and run... (5 Replies)
Discussion started by: Hope
5 Replies