I am running a script to generate a report and mail it to an email address.
When I am trying to validate whether the file is a 0 kb file, I am getting the below error.
Code:
Error: "Syntax error; unexpected end of file"
Any suggestions please?
Code:
Code:
#!/bin/sh
. $HOME/.bash_profile
sqlplus /@conn<<EOF
WHENEVER SQLERROR EXIT 1 ROLLBACK
WHENEVER OSERROR EXIT 1 ROLLBACK
SET MARKUP HTML ON
SET PAGESIZE 50000
SET FEEDBACK OFF
@/home/usr/scripts/script.sql;
EOF
CDATE=$CDATE"`date +"%y%m%d"`.xls";
ODFILENAME="/home/usr/reports/ ";
ODFILENAME=$ODFILENAME"$CDATE";
if [ -s "$ODFILENAME" ]; then
BODY=$BODY"Please find the extract."
else
BODY=$BODY"Zero KB file."
fi
mailx < send email >
Script.sql:
col spoolname new_value spoolname;
select 'draftExtract'||to_char(sysdate, 'yymmdd')||'.xls' spoolname from dual;
spool /home/usr/MIReports/&spoolname;
Select * from schema.file1;
spool OFF;
col spoolname new_value spoolname;
select 'Extract2'||to_char(sysdate, 'yymmdd')||'.xls' spoolname from dual;
spool /home/usr/MIReports/&spoolname;
Select * from schema.file2;
spool OFF;
SET MARKUP HTML OFF;
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by Pradeep_Raj; 03-15-2018 at 07:16 AM..
Reason: Added CODE tags.
I am trying to run the script bellow but its given me "syntax error at line 20 :'done' unexpected." error message"
can someone check to see if the script is ok? and correct me pls.
Today is my first day with scripting.
Gurus should pls help out
#!/bin/ksh
# Purpose: Check to see if file... (3 Replies)
hi there
i write one awk script file in shell programing
the code is related to dd/mm/yy to month, day year format
but i get an error
please can anybody help me out in this problem ??????
i give my code here including error
awk `
# date-month -- convert mm/dd/yy to month day,... (2 Replies)
one of my script as follows
HOME=/apps/logs
mv $HOME/cron.log $HOME/cron.log.`date +%Y-%m-%d`
touch $HOME/cron.log
fi
i am getting error as follows
on the last line we are getting ...
"syntax error near unexpected token `fi' "
please suggest.... (4 Replies)
I have a very simple script that reads in the contents of a file (_open.txt) into an array "lyrics":
#!/bin/sh
# read in the text
lyrics=( `cat _open.txt` | tr '\n' ' ')
exit 0
It gives the following error message:
./lyrics.sh: 1: Syntax error: word unexpected (expecting ")")
I have... (9 Replies)
Hello forum,
I hope my problem is easy to solve for someone in here!
My main task is to copy a large amount of imap-accounts from one server to another. There is a tool (Perl) called imapsync which does the job exellent. Unfortunately I'm only able to run it on one account at a time.
After... (3 Replies)
the below code will search attr string inside makefile under the modelno on given path.
echo "Enter model no for searching string inside makefile"
read inputs2
#find /pools/home_unix/sapte/work/models/model/$inputs2 -name "makefile" | xargs grep "attr" \;
#;;I am getting below error.... (7 Replies)
Hi Techies,
can anyone please debug the following Script and let me know what is going wrong here.
im getting the following error
#!/usr/bin/bash
# ##############################################################################################
#
# Variables
#
#... (2 Replies)
Hi All,
Please hav a look at the below peice of script and let me know if there are any syntax errors.
i found that the below peice of Script is causing issue. when i use SFTP its working fine, but there is a demand to use FTP only. please find below code and explain if anything is wrong... (1 Reply)
While i m running below code, it is giving me the error"syntax error at line 15: `end of file' unexpected".
Pls let me know what is wrong here..i tried many ways, but no luck
dbSID="SWQE"
usrname="apps"
password="Wrgthrk3"
count=0
while
do
sqlplus $usrname/$password@$dbSID... (5 Replies)
#!/bin/bash
#--------------------------------------------------------
# Setup prompt
# Author Zeeshan Mirza
# Data: 06-08-2017
#--------------------------------------------------------
if
then
. ./.profile_custom_pre
fi
umask 022
set -o vi
export EDITOR=vi
export VISUAL=vi... (3 Replies)
Discussion started by: getzeeshan
3 Replies
LEARN ABOUT PHP
cubrid_error
CUBRID_ERROR(3) 1 CUBRID_ERROR(3)cubrid_error - Get the error messageSYNOPSIS
string cubrid_error ([resource $connection])
DESCRIPTION
The cubrid_error(3) function is used to get the error message that occurred during the use of CUBRID API. Usually, it gets error message
when API returns false as its return value.
PARAMETERS
o $connection
-The CUBRID connection.
RETURN VALUES
Error message that occurred.
EXAMPLES
Example #1
cubrid_error(3) example
<?php
$con = cubrid_connect('localhost', 33000, 'demodb', 'dba', '');
$req = cubrid_execute($con, "select id, name from person");
if ($req) {
while (list ($id, $name) = cubrid_fetch($req))
echo $id, $name;
} else {
echo "Error Code: ", cubrid_errno($con);
echo "Error Message: ", cubrid_error($con);
}
?>
The above example will output:
Error Code: -493 Error Message: Syntax: Unknown class "person". select id, [name] from person
SEE ALSO cubrid_errno(3), cubrid_error_code(3), cubrid_error_msg(3).
PHP Documentation Group CUBRID_ERROR(3)
03-15-2018
