Sponsored Content
Full Discussion: Mail from unix box
Top Forums Shell Programming and Scripting Mail from unix box Post 302084958 by aigles on Monday 14th of August 2006 10:33:16 AM
Old 08-14-2006
The same without PL/SQL :
Code:
X=`sqlplus -s user/pwwd@domain<<eof
SET HEAD OFF FEED OFF PAGES 0
Select count(*) from DBG_INITIATIVES_CHANGE;
eof`
if [ $X -gt 0 ]
then
mailx -s "count is greater than zero" abcd@xyz.com
else
echo "count is zero"
fi

Jean-Pierre.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

VPN client (windows Box),and Server (Unix Box)

If I want to access unix box via VPN tunnel,from windows box. What sould I configure on the windows client PC, and what should I enable on the Unix Server box ? I am using Solaris V10 intel platform, and I am using windows XP, and 2003 for client (0 Replies)
Discussion started by: zillah
0 Replies

2. UNIX for Dummies Questions & Answers

Running UNIX commands remotely in Windows box from Unix box – avoid entering password

I am able to run the UNIX commands in a Windows box from a UNIX box through "SSH" functionality. But whenever the SSH connection is established between UNIX and Windows, password for windows box is being asked. Is there a way to avoid asking password whenever the SSH connection is made? Can I... (1 Reply)
Discussion started by: D.kalpana
1 Replies

3. UNIX for Dummies Questions & Answers

Receive e-mail on unix box

Hi, I am not sure if it is a good question or not. Is there a unix utility which can be configured with exchange server and then receive e-mails? Thanks! (4 Replies)
Discussion started by: DejaVu
4 Replies

4. Shell Programming and Scripting

how to compare all files in one unix box has been to copied to another unix box

Hi our unix admin has copied all files from one unix box to new unix box. We just need to confirm that all the file systems are copied properly. How to validate. (9 Replies)
Discussion started by: sravanreddym
9 Replies

5. UNIX for Dummies Questions & Answers

unix script to check if rsh to box and send status mail

rshstatus=`rsh -n lilo /db/p2/oracle/names9208/restart_names.sh` if $rshstatus <>0 then errstatus=1 mailx -s "xirsol8dr" ordba@xxx.com >> $log_dr else if errstatus=0 echo "status to xirsol8dr successful" can anyone provide if this is t he correct way to do this or is there a better way? (1 Reply)
Discussion started by: bpm12
1 Replies

6. Shell Programming and Scripting

Unix Mail Box

Hi Friends, I'm new to Unix. I have a fbackup step like /bin/nice /etc/fbackup -f /dev/rmt/0m -i / -I /opt/monitrol/tmp/Index.full 2 > /var/adm/error.log the errors for this step is redirected to a log file. How can I make to trigger mails when error occurs. Please suggest. Thanks in... (4 Replies)
Discussion started by: avik.nandi
4 Replies

7. Shell Programming and Scripting

ftp file starting with particular name on Windows box to Unix box using shell script

Hello all ! I'm trying to write a shell script (bash) to ftp a file starting with particular name like "Latest_" that is present on a Windows box to UNIX server. Basically I want to set this script in the cron so that daily the new build that is posted on the Windows box can be downloaded to the... (2 Replies)
Discussion started by: vijayb4u83
2 Replies

8. Solaris

Mail system Configuration issue on UNIX box

Hi, I wanted to configure a mail system on my UNIX box. For that I read a document Sun Internet Mail Server 3.5 Advanced Installation Guide: Contents which is actually quite useful document but I am not sure from where can I bring patch? Is this patch will come in any CD form which I need to run... (1 Reply)
Discussion started by: Dhruvak
1 Replies

9. Shell Programming and Scripting

Clean up UNIX mail box using script

Hi, I would like to clean up by unix mail mail box thru some script command.. I do know how to delete from mail box ... e.g. $ mail ? d* ? quit But I need to clean up thru some command which I can use in my script before sending any email.. Thanks in advance! (1 Reply)
Discussion started by: pareshkp
1 Replies

10. Shell Programming and Scripting

UNIX mail box

Currrently I am not able to send/receive any emails to email id. I believe my mail box is full in server. could you please let me kknow to clear the emails in the unix server. (2 Replies)
Discussion started by: ramkumar15
2 Replies
MYSQLNDUHCONNECTION(3)							 1						    MYSQLNDUHCONNECTION(3)

The MysqlndUhConnection class

INTRODUCTION
CLASS SYNOPSIS
MysqlndUhConnection MysqlndUhConnection Methods o public bool MysqlndUhConnection::changeUser (mysqlnd_connection $connection, string $user, string $password, string $database, bool $silent, int $passwd_len) o public string MysqlndUhConnection::charsetName (mysqlnd_connection $connection) o public bool MysqlndUhConnection::close (mysqlnd_connection $connection, int $close_type) o public bool MysqlndUhConnection::connect (mysqlnd_connection $connection, string $host, string $use", string $password, string $database, int $port, string $socket, int $mysql_flags) o public MysqlndUhConnection::__construct (void ) o public bool MysqlndUhConnection::endPSession (mysqlnd_connection $connection) o public string MysqlndUhConnection::escapeString (mysqlnd_connection $connection, string $escape_string) o public int MysqlndUhConnection::getAffectedRows (mysqlnd_connection $connection) o public int MysqlndUhConnection::getErrorNumber (mysqlnd_connection $connection) o public string MysqlndUhConnection::getErrorString (mysqlnd_connection $connection) o public int MysqlndUhConnection::getFieldCount (mysqlnd_connection $connection) o public string MysqlndUhConnection::getHostInformation (mysqlnd_connection $connection) o public int MysqlndUhConnection::getLastInsertId (mysqlnd_connection $connection) o public void MysqlndUhConnection::getLastMessage (mysqlnd_connection $connection) o public string MysqlndUhConnection::getProtocolInformation (mysqlnd_connection $connection) o public string MysqlndUhConnection::getServerInformation (mysqlnd_connection $connection) o public string MysqlndUhConnection::getServerStatistics (mysqlnd_connection $connection) o public int MysqlndUhConnection::getServerVersion (mysqlnd_connection $connection) o public string MysqlndUhConnection::getSqlstate (mysqlnd_connection $connection) o public array MysqlndUhConnection::getStatistics (mysqlnd_connection $connection) o public int MysqlndUhConnection::getThreadId (mysqlnd_connection $connection) o public int MysqlndUhConnection::getWarningCount (mysqlnd_connection $connection) o public bool MysqlndUhConnection::init (mysqlnd_connection $connection) o public bool MysqlndUhConnection::killConnection (mysqlnd_connection $connection, int $pid) o public array MysqlndUhConnection::listFields (mysqlnd_connection $connection, string $table, string $achtung_wild) o public void MysqlndUhConnection::listMethod (mysqlnd_connection $connection, string $query, string $achtung_wild, string $par1) o public bool MysqlndUhConnection::moreResults (mysqlnd_connection $connection) o public bool MysqlndUhConnection::nextResult (mysqlnd_connection $connection) o public bool MysqlndUhConnection::ping (mysqlnd_connection $connection) o public bool MysqlndUhConnection::query (mysqlnd_connection $connection, string $query) o public bool MysqlndUhConnection::queryReadResultsetHeader (mysqlnd_connection $connection, mysqlnd_statement $mysqlnd_stmt) o public bool MysqlndUhConnection::reapQuery (mysqlnd_connection $connection) o public bool MysqlndUhConnection::refreshServer (mysqlnd_connection $connection, int $options) o public bool MysqlndUhConnection::restartPSession (mysqlnd_connection $connection) o public bool MysqlndUhConnection::selectDb (mysqlnd_connection $connection, string $database) o public bool MysqlndUhConnection::sendClose (mysqlnd_connection $connection) o public bool MysqlndUhConnection::sendQuery (mysqlnd_connection $connection, string $query) o public bool MysqlndUhConnection::serverDumpDebugInformation (mysqlnd_connection $connection) o public bool MysqlndUhConnection::setAutocommit (mysqlnd_connection $connection, int $mode) o public bool MysqlndUhConnection::setCharset (mysqlnd_connection $connection, string $charset) o public bool MysqlndUhConnection::setClientOption (mysqlnd_connection $connection, int $option, int $value) o public void MysqlndUhConnection::setServerOption (mysqlnd_connection $connection, int $option) o public void MysqlndUhConnection::shutdownServer (string $MYSQLND_UH_RES_MYSQLND_NAME, string $"level") o public bool MysqlndUhConnection::simpleCommand (mysqlnd_connection $connection, int $command, string $arg, int $ok_packet, bool $silent, bool $ignore_upsert_status) o public bool MysqlndUhConnection::simpleCommandHandleResponse (mysqlnd_connection $connection, int $ok_packet, bool $silent, int $com- mand, bool $ignore_upsert_status) o public bool MysqlndUhConnection::sslSet (mysqlnd_connection $connection, string $key, string $cert, string $ca, string $capath, string $cipher) o public resource MysqlndUhConnection::stmtInit (mysqlnd_connection $connection) o public resource MysqlndUhConnection::storeResult (mysqlnd_connection $connection) o public bool MysqlndUhConnection::txCommit (mysqlnd_connection $connection) o public bool MysqlndUhConnection::txRollback (mysqlnd_connection $connection) o public resource MysqlndUhConnection::useResult (mysqlnd_connection $connection) PHP Documentation Group MYSQLNDUHCONNECTION(3)
All times are GMT -4. The time now is 10:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy