Sponsored Content
Full Discussion: Unix script enhancement
Top Forums Shell Programming and Scripting Unix script enhancement Post 302464301 by msrahman on Tuesday 19th of October 2010 06:03:35 PM
Old 10-19-2010
Tried point No. 2.

I tried the second point. It loads the data, and e-mails the log file to the user, but it does not e-mail the total no. of files loaded in the table to the user.

Instead it diplays the result on the background itself.
Code:
 
Message  more message       95 !
SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 19 16:07:37 2010
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
drop index zx01193.bene_elig
                   *
ERROR at line 1:
ORA-01418: specified index does not exist
 
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Password:
SQL*Loader: Release 11.2.0.1.0 - Production on Tue Oct 19 16:07:37 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Commit point reached - logical record count 64
Commit point reached - logical record count 95

Here's the script that i added to the current script:
Code:
echo "Message $variables more message $(wc -l </space/dbexport/PHR/data/eligExport.csv ) !" ; uuencode $logfile $basename  | mailx -s "$subject" "$to"

Can you please do the changes to the above script, which will e-mail the total records loaded into the table via e-mail to the user.

Thanks

---------- Post updated at 05:03 PM ---------- Previous update was at 04:11 PM ----------

Tried Point No.1.
Table loaded with data,, but the e-mail does not e-mail the user that the input file contains duplicate records in it.

Thoughts please,,
Code:
compare
$( wc -l </space/dbexport/PHR/data/eligExport.csv ) to $( sort -u /space/dbexport/PHR/data/eligExport.csv | wc -l )
echo "Message $variables more message!" ; uuencode $logfile $basename  | mailx -s subject-line abc@gmail.com


Last edited by Scott; 10-26-2010 at 06:06 PM..
 

3 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Linux Multipathing Enhancement

We are searching for DEVICE MAPPER TABLE FORMAT and how to access it through user space?? We are working on enhancement in multipatrhing as 1] scalable path testing 2] event mechanism 3] i/o load sharing. So we need to access device info as well as all paths to that device, devices status,paths... (1 Reply)
Discussion started by: rajaryan99
1 Replies

2. UNIX for Dummies Questions & Answers

Linux Multipath Enhancement

Hi.. when i delete a Lun from a Array on a SAN, and again when i create a Lun it shows that the newly created Lun has the ID of the Old deleted Lun which is leading to data corruption. All this is handled by the Multipath software. can anybody help. (0 Replies)
Discussion started by: Praveen13
0 Replies

3. Shell Programming and Scripting

Pagination need enhancement.

I have below folder structure . |--summit | |----xpnldetails | |----trades | |----svar | | |------checksum | |----xpnl | |----adjustment | | |------summit | | |------ap | |----risks | |----hypopnl | |----fxeffect | |----audittrail |... (0 Replies)
Discussion started by: manas_ranjan
0 Replies
ATF-SH(1)						    BSD General Commands Manual 						 ATF-SH(1)

NAME
atf-sh [-s shell] -- interpreter for shell-based test programs SYNOPSIS
atf-sh script DESCRIPTION
atf-sh is an interpreter that runs the test program given in script after loading the atf-sh(3) library. atf-sh is not a real interpreter though: it is just a wrapper around the system-wide shell defined by ATF_SHELL. atf-sh executes the inter- preter, loads the atf-sh(3) library and then runs the script. You must consider atf-sh to be a POSIX shell by default and thus should not use any non-standard extensions. The following options are available: -s shell Specifies the shell to use instead of the value provided by ATF_SHELL. ENVIRONMENT
ATF_LIBEXECDIR Overrides the builtin directory where atf-sh is located. Should not be overridden other than for testing purposes. ATF_PKGDATADIR Overrides the builtin directory where libatf-sh.subr is located. Should not be overridden other than for testing purposes. ATF_SHELL Path to the system shell to be used in the generated scripts. Scripts must not rely on this variable being set to select a specific interpreter. EXAMPLES
Scripts using atf-sh(3) should start with: #! /usr/bin/env atf-sh Alternatively, if you want to explicitly choose a shell interpreter, you cannot rely on env(1) to find atf-sh. Instead, you have to hardcode the path to atf-sh in the script and then use the -s option afterwards as a single parameter: #! /path/to/bin/atf-sh -s/bin/bash ENVIRONMENT
ATF_SHELL Path to the system shell to be used in the generated scripts. SEE ALSO
atf-sh(3) BSD
September 27, 2014 BSD
All times are GMT -4. The time now is 11:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy