Hi,
Here I am trying to query database and check a value, if the value not matches then I wants to re-query the database.Once the value matches, I want to email the reqidstatus_log.txt file. Database query produces a file reqidstatus_log.txt which contains result.
But the query not working as per my expectations. Need your help on this ....
OS: Solaris Sparc 10
Shell Type: ksh
###############
Code:
while grep -i "no rows selected" reqidstatus_log.txt
do
sleep 30
sqlplus -s apps/<PASSWORD> << ENDOFSQL
define reqid=107019657;
spool reqidstatus_log.txt
select REQUEST_ID,PHASE_CODE,STATUS_CODE
from fnd_conc_req_summary_v where request_id='1070196571' and phase_code='C';
ENDOFSQL
done
uuencode reqidstatus_log.txt reqidstatus_log.txt | mailx -s "reqidstatus_log.txt" xyz@abc.com
##################
Thanks,
Raj
Moderator's Comments:
Please use code tags when posting data and code samples!
Last edited by vgersh99; 10-24-2011 at 10:21 AM..
Reason: code tags, please!
I would need to with making while loop logic working in shell program when I am new into the shell programing
1) I would need to try to get the file from the remote side ----need to try 15 mins apart for 4 times and terminate the program if file is not available....
I would need to know how I... (4 Replies)
hi, unix wizards,
i have a question about the logic of my inner for loop below. first, what i am trying to do is to write a script called create_account that automatically creates mysql accounts. the user can provide a user_name or a group_id as an argument (and the script can take multiple... (1 Reply)
i need to log the feedback from the ftp server as i'm performing some deletes.
the only way i know of to do this is with the inline redirect << EOF
... but from there to the closing EOF, it's like i'm at the ftp command prompt, so I don't know how to have ksh script logic in there
I have an... (3 Replies)
Hi Friends,
I have to do write a shell file based on one flag.If that flag value is 'N' then process look in $DATA are and the normal process continue.If vaule is 'P' then it check for the files in different location $CONV and move those file in $DATA area and rest of the process... (2 Replies)
Hi,
I have a requirement as follows. Have 3 files. Need to match up the data in each one of them and sum up the data by a field and display it. example given below.
File 1 : Name, Emp id
File 2 : Empid, Subject,
File 3 : Subject, Score, Class
Match Emp id in File 1 and File 2 and then... (7 Replies)
Discussion started by: preethgideon
7 Replies
LEARN ABOUT DEBIAN
cyrus-ctl_cyrusdb
CTL_CYRUSDB(8) System Manager's Manual CTL_CYRUSDB(8)
*
NAME
ctl_cyrusdb - perform operations common to all Cyrus databases
SYNOPSIS
ctl_cyrusdb [ -C config-file ] -r [ -x ]
ctl_cyrusdb [ -C config-file ] -c
DESCRIPTION
Ctl_cyrusdb is used to perform various administrative operations on the Cyrus databases.
Ctl_cyrusdb reads its configuration options out of the imapd.conf(5) file unless specified otherwise by -C. The configdirectory option is
used to determine the default location of the Cyrus databases.
OPTIONS -C config-file
Read configuration options from config-file.
-r Recover the databases after an application or system failure. Also performs database cleanup like removing mailbox reservations
(and any associated mailbox files).
All mailbox files are also checked to make sure the file format matches the configured database type in imapd.conf. If not, the
file is automatically converted using the same logic as cvt_cyrusdb.
-x Used with -r to recover the database only. (Prevents database cleanup).
-c Checkpoint and archive the databases. Changes to the database which are part of committed transactions are written to disk. Also,
a hot backup of the databases is made and inactive log files are removed.
FILES
/etc/imapd.conf
SEE ALSO imapd.conf(5), cyrmaster(8)CMU Project Cyrus CTL_CYRUSDB(8)
10-24-2011
while loop logic
