10-28-2010
Hi,
I tried running the script with "CONDITION , but its still the same.
Script:
( echo "CONDITION, ENCOUNTER & PROCEDURE LOAD PROCESS FINISHED SUCCESSFULLY", The total records loaded into the tables are:
$( wc -l < /space/dbexport/PHR/data/conditionExport_test.csv);
$( wc -l < /space/dbexport/PHR/data/encounterExport.csv);
$( wc -l < /space/dbexport/PHR/data/procedureExport.csv) ; $logfile $basename ) | mailx -s "$subject" "$to"
id11355@noridian.com
Error:
Commit point reached - logical record count 10000
./sqlldrclaims_test1.sh[44]: 2000: not found
./sqlldrclaims_test1.sh[45]: 10000: not found
./sqlldrclaims_test1.sh[46]: 10000: not found
Is there any other alternative for this?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi everyone!
I'm trying to create a database monitoring script that reads an alert file and sends an error message if it can 'grep' a particular string.
Is there a way to send this message to a mail client using SMTP?
Even better, is there any place on this site that has these kinds of... (5 Replies)
Discussion started by: solaris73
5 Replies
2. Shell Programming and Scripting
How do get the counts by excluding header and tailer.
wc -l customer_data*.0826
31 customer_data_1.0826
57 customer_data_2.0826
456 customer_data_3.0826
668 customer_data_4.0826
789 customer_data_5.0826
2344 customer_data_6.0826
13457 customer_data_7.0826... (6 Replies)
Discussion started by: zooby
6 Replies
3. Shell Programming and Scripting
Hi guys...
I am busy writing a script to notify me via an mail if my application is down. I have done that.
Now I want this script to stop sending mails after five mails were sent but the script should keep on checking the application.
When the application is up again that count should be... (5 Replies)
Discussion started by: Phuti
5 Replies
4. Shell Programming and Scripting
Hi,
I have a requirement to send a mail with multiple files attached to it and along with the text message in the mail.
I am trying sumthing like below but it only sends me the text message and no files attached to the mail.
----------------------------------------
( uuencode file1... (1 Reply)
Discussion started by: sachinkl
1 Replies
5. UNIX for Dummies Questions & Answers
HI ,
I am having a huge comma delimiter file, I have to append the following four lines before the starting of the file through a shell script.
FILE NAME = TEST_LOAD
DATETIME = CURRENT DATE TIME
LOAD DATE = CURRENT DATE
RECORD COUNT = TOTAL RECORDS IN FILE
Source data
1,2,3,4,5,6,7... (7 Replies)
Discussion started by: shruthidwh
7 Replies
6. Shell Programming and Scripting
Hi,
I need help regarding below concern.
There is a script and it has 7 existing files(in a path say,. usr/appl/temp/file1.txt) and I need to create one new blank file say “file_count.txt” in the same script itself.
Then the new file <file_count.txt> should store all the 7 filenames and... (1 Reply)
Discussion started by: pr293
1 Replies
7. Shell Programming and Scripting
Hi,
I want a script that can perform the following tasks,
1)Open command prompt and navigate to certain path (for eg: C:\Programs\) and then execute the below command on a daily basis,
list -C <client name> -t 13 -l -R -s <previous_day> /D > D:\Prgrams\list_currentdate.txt
Note: There... (2 Replies)
Discussion started by: cratercrabs
2 Replies
8. Red Hat
Whats the difference between mail and mailx?
I'm trying to troubleshoot a problem where I can send mail from server A with this `echo $MESSAGE | mail -s "$SUBJECT" -r $FROM $RECIPIENTS` command but executing the same command from server B throws me this error (Both servers are RHEL)
... (1 Reply)
Discussion started by: RedSpyder
1 Replies
9. UNIX for Beginners Questions & Answers
Hie,
I need to attach an .xlsx file as an attachment to a mail. I have used the mail option but i dont think there is anything for attachment. Can you show me how else can i do it? I am not allowed to install mutt since it is a workplace and they have their restrictions. And its a Bash Shell (2 Replies)
Discussion started by: barryallen
2 Replies
10. Shell Programming and Scripting
Hi Gurus,
I need to remove duplicate line in file and update TRAILER (last line) record count. the file is comma delimited, field 2 is key to identify duplicated record.
I can use below command to remove duplicated. but don't know how to replace last line 2nd field to new count.
awk -F","... (11 Replies)
Discussion started by: green_k
11 Replies
SHAR(1) BSD General Commands Manual SHAR(1)
NAME
shar -- create a shell archive of files
SYNOPSIS
shar file ...
DESCRIPTION
shar writes an sh(1) shell script to the standard output which will recreate the file hierarchy specified by the command line operands.
Directories will be recreated and must be specified before the files they contain (the find(1) utility does this correctly).
shar is normally used for distributing files by ftp(1) or mail(1).
SEE ALSO
compress(1), mail(1), tar(1), uuencode(1)
BUGS
shar makes no provisions for special types of files or files containing magic characters.
EXAMPLES
To create a shell archive of the program ls(1) and mail it to Rick:
cd ls
shar `find . -print` | mail -s "ls source" rick
To recreate the program directory:
mkdir ls
cd ls
...
<delete header lines and examine mailed archive>
...
sh archive
HISTORY
The shar command appears in 4.4BSD.
SECURITY CONSIDERATIONS
It is easy to insert trojan horses into shar files. It is strongly recommended that all shell archive files be examined before running them
through sh(1). Archives produced using this implementation of shar may be easily examined with the command:
egrep -v '^[X#]' shar.file
4.4BSD June 6, 1993 4.4BSD