Unix script enhancement Post: 302464301

Sponsored Content

Top Forums Shell Programming and Scripting Unix script enhancement Post 302464301 by msrahman on Tuesday 19th of October 2010 06:03:35 PM

10-19-2010

Registered User

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..

msrahman

View Public Profile for msrahman

Find all posts by msrahman

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...

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.

3. Shell Programming and Scripting

Pagination need enhancement.

LEARN ABOUT DEBIAN

sql::reservedwords

SQL::ReservedWords(3pm) 				User Contributed Perl Documentation				   SQL::ReservedWords(3pm)

NAME

       SQL::ReservedWords - Reserved SQL words by ANSI/ISO

SYNOPSIS

	  if ( SQL::ReservedWords->is_reserved( $word ) ) {
	      print "$word is a reserved SQL word!";
	  }

DESCRIPTION

       Determine if words are reserved by ANSI/ISO SQL standard.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either "SQL:1992", "SQL:1999" or "SQL:2003".

       is_reserved_by_sql1992( $word )
	   Returns a boolean indicating if $word is reserved by "SQL:1992".

       is_reserved_by_sql1999( $word )
	   Returns a boolean indicating if $word is reserved by "SQL:1999".

       is_reserved_by_sql2003( $word )
	   Returns a boolean indicating if $word is reserved by "SQL:2003".

       reserved_by( $word )
	   Returns a list with SQL standards that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_sql1992
       is_reserved_by_sql1999
       is_reserved_by_sql2003
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords::DB2

       SQL::ReservedWords::MySQL

       SQL::ReservedWords::ODBC

       SQL::ReservedWords::Oracle

       SQL::ReservedWords::PostgreSQL

       SQL::ReservedWords::SQLite

       SQL::ReservedWords::SQLServer

       ISO/IEC 9075:1992 Database languages -- SQL

       ISO/IEC 9075-2:1999 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)

       ISO/IEC 9075-2:2003 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28						   SQL::ReservedWords(3pm)

3 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Linux Multipathing Enhancement

Discussion started by: rajaryan99

2. UNIX for Dummies Questions & Answers

Linux Multipath Enhancement

Discussion started by: Praveen13

3. Shell Programming and Scripting

Pagination need enhancement.

Discussion started by: manas_ranjan

LEARN ABOUT DEBIAN

sql::reservedwords