Script not spooling in the designated file. Post: 303029495

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Script not spooling in the designated file. Post 303029495 by clef on Sunday 27th of January 2019 07:37:46 PM

01-27-2019

Registered User

Script not spooling in the designated file.

Hi, I need to write a script that will run a simple select count(*) query and sends the result of that query to me via email.

Here's what I already have.

Code:

#!/bin/ksh
######################################################################
# File Name  : counts.sh
# Created    : 2019/27/19
# Author     : 
#-----------------------------------------------------------------------
# $Revision: 1.0 $
# $Date: 2019/01/27 08:00:00 $
#-----------------------------------------------------------------------
# Modification History:
# No      Date       Author         Note
#
#-----------------------------------------------------------------------
#
#
########################################################################
DB_USERNAME=$1
DB_PASSWORD=$2
DB_DBASE=$3

#------------------------------------------------------------
# Start Log
#------------------------------------------------------------
DB_CONN=${DB_USERNAME}/${DB_PASSWORD}@${DB_DBASE}
LOG_DATETIME=`date +%Y-%m-%d:%H:%M:%S`
LOG_FILE=/tmp/$LOG_DATETIME.log
EGREP=/bin/egrep
ORA_ERR_STR=ORA

#==Start Counting ========================================

sqlplus -S ${DB_CONN} > $LOG_FILE << ORAEND

set serveroutput on;
set feedback off
SPOOL /tmp/counts.txt
PROMPT COUNTS

SELECT COUNT(*) FROM schema.db;

spool off;
ORAEND


mailx -s "Counts on $DB_DBASE is" user@gmail.com < /tmp/counts.txt		
#===end of script=========#

I'm calling the script using

Quote:

nohup ksh counts.sh user password db

The script is already sending an email "Counts on $DB_DBASE is" without the actual result of the query.
I'm a total stranger in Shell scripting and just basing my work on the existing scripts in our project.

clef

View Public Profile for clef

Find all posts by clef

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Spooling a log file with timestamp

Hi From shell script i am invoking sqlplus to connect to oracle database and then i spool a csv file as with output. What i want to do is to change the file name with timestamp on it so after spooling finish shell script change file name with time stamp. can someone help me to do that . Thanks...

2. Shell Programming and Scripting

spooling through shell script

Hi, I want to spool the output from a .sql file to a .txt file through shell script. the contents of .sql are: spool /arboru02/scripts/customer_profile_def.txt select profile_id ||','|| account_no from customer_profile_def; spool off exit and shell scrip is like: #!/bin/sh...

3. UNIX for Dummies Questions & Answers

Option in sql script to include column headers when spooling file to .csv format

Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement. Thanks, Akbar

4. UNIX for Dummies Questions & Answers

Creating a Tar file while files are spooling

Hi I have done a search for this but couldn't find much on it. I am creating a tar file with the command below tar cvf /export/home/user/backup/*Will this is being created I have a job spooling to 5 texts files in the following directory /export/home/user/backup/STATS/ The tar files...

5. Shell Programming and Scripting

Spooling file to excel

Hi , Im spooling file from oracle to csv using shell script. Below is the code im using.. The o/p is not coming in right format.. Please help me out in this.. O/p is coming as header till batch id ,im not able to see date_stored,type,type1.. Please any one can give me some suggestion ...

6. Shell Programming and Scripting

Script not spooling in result file

Hi everyone and nice to meet you :) I'm having some issues with a script I'm writing. It's probably most chaotic, I'm no ksh guru, but the idea is to extract an ID with that query, spool it into a file, and read that file making the ID a variable. This has to be done for every row extracted by...

7. Shell Programming and Scripting

Substitute newline with tab at designated field separator

Hello, I need to replace newline with tab at certain lines of the file (every four lines is a record). infile.fq: @GAIIX-300 ATAGTCAAAT + _SZS^\\\cd @GAIIX-300 CATACGACAT + hhghfdffhh @GAIIX-300 GACGACGTAT + gggfcfoutfile: @GAIIX-300 ATAGTCAAAT + _SZS^\\\cd @GAIIX-300 ...

8. UNIX for Dummies Questions & Answers

Spooling data from the database in .csv file with boundary

Hi Guys, Another questions to the genius over here. I have spool the dataf from the database into a .csv file. But can it be possible to have all the rows and column with the boundaries..for example the .csv file which i have is as below: 20140327 BU 9A 3 20140327 SPACE 9A 3 20140327...

9. UNIX for Beginners Questions & Answers

Spooling File to My Desktop From Back-end using shell script

Hello all, I am trying to spool a SQL query output file from back-end to desktop in a certain path but it didn't work,the query writes the output in a file in the same directory at the back-end. note : i use the same query in sql developper and file was created in the desired path fine code...

LEARN ABOUT DEBIAN

checker

checker(1)						      General Commands Manual							checker(1)

NAME

       checker - SPARK Proof Checker

SYNOPSIS

       checker [OPTIONS] [FILE]

DESCRIPTION

       The  SPARK Proof Checker can be used to discharge verification conditions produced by the Examiner (*.vcg), possibly simplified by the Sim-
       plifier (*.siv).  This command is usually used when verification conditions cannot be discharged automatically by the Simplifier.

       By default checker runs in interactive mode.  It accepts commands from user and writes them into a cmd file (or	other  file  specified	by
       -command_log  option).  This file can be used later to run checker in batch mode (using option -execute).  Additionally, proof log is writ-
       ten into a plg file.

OPTIONS

       A summary of options is included below.	All options may be abbreviated to the shortest unique prefix.

       -help  Show summary of options.

       -version
	      Display version information.

       -plain Adopt a plain output style (e.g. no dates or version numbers).

       -overwrite_warning
	      Confirmation needed to overwrite command or proof log files.

       -command_log=LOG_FILE
	      Specify file name for the command log file.

       -proof_log=PLG_FILE
	      Specify file name for the proof log file.

       -execute=LOG_FILE
	      Execute a previously generated command log file.

       -resume
	      Resume a previously saved session.

FILES

       /usr/share/spark/checker/rules/*
	      Checker rules database.

SEE ALSO

       spark(1), sparksimp(1), spadesimp(1), pogs(1).

AUTHOR

       This manual page was written by Eugeniy Meshcheryakov <eugen@debian.org>, for the Debian project (and may be used by others).

								    3 June 2011 							checker(1)