10-24-2008
if [-r /apps/vcr/appl/config/env ]$
then . /apps/vcr/appl/config/env;$
. /apps/vcr/appl/config/env_cust;$
else $
. /apps/vcred/appl/config/env ;$
. /apps/vcred/appl/config/env_cust ;$
$
fi$
$
day_mon=`date +%d`$
day_week=`date +%u`$
SQL_count="select count(*) from vcradmin.mv001ar_cust_mon_prior_yr" #dwspec.ar_customer_daily@ribp.world"$
SQL_sets="set pagesize 5000;$
set echo off;$
set heading off;$
set feedback off;$
set termout off;$
set trimspool on;"$
conn_oracle(){ $
row_cnt=`sqlplus -s $DBUSER/$DBPWD@$DBHOST<< EOF$
$SQL_sets$
$SQL_count$
exit$
EOF` $
echo "total row count is "$row_cnt$
}$
if(($day_mon >= 15 || $day_mon <= 25 && $day_week == 5 )) $
then$
for i in 1 2 3 4 $
do$
$
conn_oracle$
echo "no of row count is $row_count"$
if(($row_cnt >= 1))$
then$
$
echo "database is up and run the code here $row_cnt" $
$
exit$
$
$
else $
$
sleep 10$
continue #call the script here$
echo "data base is up script is going run "$
$
$
fi$
done$
$
else$
echo "It is not 3rd sunday the db is available script runs without DB check"$
fi$
$
$
$
$
I have done cat -vet script as above now i am not getting the result from count(*) from the db.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi there
i write one awk script file in shell programing
the code is related to dd/mm/yy to month, day year format
but i get an error
please can anybody help me out in this problem ??????
i give my code here including error
awk `
# date-month -- convert mm/dd/yy to month day,... (2 Replies)
Discussion started by: Herry
2 Replies
2. AIX
--------------------------------------------------------------------------------
Hello, help me please.
I am trying to create a mksysb bakup using nim. I am geting this error, how to correct it ? :
Command : failed stdout: yes stderr: no... (9 Replies)
Discussion started by: astjen
9 Replies
3. Shell Programming and Scripting
My script is throwing the error 'Syntax error: redirection unexpected'
My line of code..
cat nsstatustest.html | sed s/<tr><td align="left">/<tr><td align="left" bgcolor="#000000"><font color="white">/ > ztmp.Ps23zp2s.2-Fpps3-wmmm0dss3
HTML tags are getting in the way but they're needed to... (3 Replies)
Discussion started by: phpfreak
3 Replies
4. Programming
Hello, the following is generating a error at the line "tmprintf(&tmBundle, _TMC("{0}"),Prompt);"... a bit lost as I am diving into this debug...
Thank you in advance...
int H_YesNo(TMCHAR *Prompt, int DefVal)
{
TMCHAR YesNo = '\0';
tmprintf(&tmBundle, _TMC("{0}"),Prompt);
while... (3 Replies)
Discussion started by: reelflytime
3 Replies
5. Shell Programming and Scripting
Help please! :confused:
I have the following error with the following file and the emails are not arriving to the email, any idea please?
ERROR: ./launch_full_backup.sh: Syntax error at line 28 : `else' is not expected.
FECHA=`date +%d%m%y%H%M`... (2 Replies)
Discussion started by: villenan
2 Replies
6. Shell Programming and Scripting
Hi All
I am quite new to Unix. Following is a shell script that i have written and getting the subject mentioned error.
#!/bin/ksh
#-------------------------------------------------------------------------
# File: ang_stdnld.ksh
#
# Desc: UNIX shell script to extract Store information.... (3 Replies)
Discussion started by: amitsinha
3 Replies
7. Shell Programming and Scripting
I have a simple shell script to read create a mysql database as a particular user. Right now, I have the password set as a variable to make sure someone does not mistype the password. I want to take the hard coded password out of the file and make the user input the password twice to make they... (2 Replies)
Discussion started by: bouncer
2 Replies
8. Linux
Hi,
I need help on following linux bash script. When I linux commands for loop or while loop on individual file it runs great. but now I want the script to run on N number of files so it gives me ambiguous redirect error on line 12 and syntax error on line 22 : (pls help );
#!/bin/bash
#... (16 Replies)
Discussion started by: Madhusudan Das
16 Replies
9. Shell Programming and Scripting
Hello,
I have another problem with my script. Please accept my apologies, but I am really nooby in sh scripts. I am writing it for first time.
My script:
returned=`tail -50 SapLogs.log | grep -i "Error"`
echo $returned
if ; then
echo "There is no errors in the logs"
fi
And after... (10 Replies)
Discussion started by: jedzio
10 Replies
LEARN ABOUT FREEBSD
boot.config
BOOT.CONFIG(5) BSD File Formats Manual BOOT.CONFIG(5)
NAME
boot.config -- Configuration file for the boot blocks
DESCRIPTION
The boot.config file contains options for the FreeBSD boot block code.
When the FreeBSD boot loader runs, it searches the ``a'' slice of the boot partition for a boot.config file (as a result, slices which are
missing an ``a'' partition require user intervention during the boot process). If the boot.config file is found, its contents are used as
the default configuration options for the boot block code and are echoed to the system console.
A valid format of this file is to put BIOS drive number, a controller type, a unit number, a partition, a kernel file name, and any other
valid boot(8) option on a single line, as it is done at the ``boot:'' prompt.
The options related to the boot image selection described below and all the other options available for boot.config are documented in detail
in the boot(8) manual page.
FILES
/boot.config parameters for the boot blocks (optional)
EXAMPLES
The command:
# echo "-P" > /boot.config
will activate the serial console of FreeBSD.
The command:
# echo "1:ad(1,a)/boot/loader" > /boot.config
will instruct the second stage of boot(8) on the first disk to boot with the third boot(8) stage from the second disk.
The command:
# echo "1:ad(1,a)/boot/loader -P" > /boot.config
will do both of the above.
SEE ALSO
boot(8), loader(8)
AUTHORS
This manual page was written by Daniel Gerzo <danger@FreeBSD.org>.
BSD
May 13, 2007 BSD