Login or Register to Ask a Question and Join Our Community

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

LEARN ABOUT DEBIAN

jifty::dbi::handle::oracle

Jifty::DBI::Handle::Oracle(3pm) 			User Contributed Perl Documentation			   Jifty::DBI::Handle::Oracle(3pm)

NAME

	 Jifty::DBI::Handle::Oracle - An oracle specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.

METHODS

   connect PARAMHASH: Driver, Database, Host, User, Password
       Takes a paramhash and connects to your DBI datasource.

   database_version
       Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.

   insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

   build_dsn PARAMHASH
       Takes a bunch of parameters:

       Required: Driver, Database or Host/SID, Optional: Port and RequireSSL

       Builds a dsn suitable for an Oracle DBI connection

   blob_params column_NAME column_type
       Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type.  The current
       Oracle implementation only supports ORA_CLOB types(112).

   apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

   distinct_query STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle

perl v5.14.2							    2011-04-26					   Jifty::DBI::Handle::Oracle(3pm)
All times are GMT -4. The time now is 06:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy