i have below code to count number of rows in file1.txt, if the row count is more than one then i have sending an email along with file1.txt attached and fail the process(do nothing if count is <=1),
if I test individually count part works good but when i include the email part its not working, couldn't figure out the issue, is the approach correct or is there a better way for this approach
Code:
#! /usr/bin/kshAttachment = file1.txtNumber_of_lines = wc -l < file1.txtEmail_Id=abc@email.comif [ $Number_of_lines > 1 ] then (echo "Find Attached the Error File which list the Error Rows from Invalid Procedure codes";uuencode $Attachment Invalid_Procedure_Codes.txt) | mail -s "[ERROR] : Invalid Procedure codes " $Email_Idfi
Last edited by srini_106; 04-02-2014 at 01:08 PM..
I'm looking for a sample of some code that will take the output from a file and generate an email that will include that text as an attachment. the script is in the borne shell. any help? (2 Replies)
a file is created on a daily basis in the name xyz_pqr_20071207.dat.i want to send the file as an attachment if the file contains more than 50 records.how can i write a script such that it will transmit the file after the file is created.i want to sed the file to say asdf@xyz.com.
please help me... (2 Replies)
I need to start off by saying that I am not much of a programmer and know enough to cause lots of trouble.
I've been writing this script to decrypt an XML feed, then parse the feed into a database. The script is executed from cron.
#!/bin/sh
PGPPATH=/path/to/directory
echo "pgp... (6 Replies)
Hi All,
I am new to the unix , i have to deliver one script very urgently
I have to write a shell script where i have i want to send email to specific email id
in this script i want
FROM to be parameterized and stored in a variable
TO to be parameterized and stored in a variable... (3 Replies)
Hello ,
I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them .
I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Hi Guys,
I have this script which will monitor oracle db process if up or down.And I want it to send email if it's down and the time it's back to online. However my script just keep on sending "Email Up" if the db is up or "Email Down" if the db is down.Is there any way to trap it so that it... (5 Replies)
Hi.
I'm new on this forum and I need if possible someone to help me with one script.
The script should act like this:
- should be run by crontab and have next parameters:
script_name $par1 $par2 $par3 $par4
where script will search in dir $par1 for files with mask $par2 and if number of... (2 Replies)
i have below code to count number of rows in file1.txt, if the row count is more than one then i have sending an email along with file1.txt attached and fail the process(do nothing if count is <=1),
if I test individually count part works good but when i include the email part its not working,... (1 Reply)
Hi Scripters, good day.
bash-4.2# df -g /apps/prd
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/xxx 64.00 4.35 94% 1269284 8% /xxx
bash-4.2#
I was wondering if there is a script when the usage of the mountpoint above hit 98%, email would be... (3 Replies)
Discussion started by: jaapar
3 Replies
LEARN ABOUT CENTOS
move
MOVE(7) PostgreSQL 9.2.7 Documentation MOVE(7)NAME
MOVE - position a cursor
SYNOPSIS
MOVE [ direction [ FROM | IN ] ] cursor_name
where direction can be empty or one of:
NEXT
PRIOR
FIRST
LAST
ABSOLUTE count
RELATIVE count
count
ALL
FORWARD
FORWARD count
FORWARD ALL
BACKWARD
BACKWARD count
BACKWARD ALL
DESCRIPTION
MOVE repositions a cursor without retrieving any data. MOVE works exactly like the FETCH command, except it only positions the cursor and
does not return rows.
The parameters for the MOVE command are identical to those of the FETCH command; refer to FETCH(7) for details on syntax and usage.
OUTPUTS
On successful completion, a MOVE command returns a command tag of the form
MOVE count
The count is the number of rows that a FETCH command with the same parameters would have returned (possibly zero).
EXAMPLES
BEGIN WORK;
DECLARE liahona CURSOR FOR SELECT * FROM films;
-- Skip the first 5 rows:
MOVE FORWARD 5 IN liahona;
MOVE 5
-- Fetch the 6th row from the cursor liahona:
FETCH 1 FROM liahona;
code | title | did | date_prod | kind | len
-------+--------+-----+------------+--------+-------
P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
(1 row)
-- Close the cursor liahona and end the transaction:
CLOSE liahona;
COMMIT WORK;
COMPATIBILITY
There is no MOVE statement in the SQL standard.
SEE ALSO CLOSE(7), DECLARE(7), FETCH(7)PostgreSQL 9.2.7 2014-02-17 MOVE(7)