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 DEBIAN
fvwm-config
fvwm-config(1) Fvwm Modules fvwm-config(1)
NAME
fvwm-config - query an existing fvwm installation
SYNOPSIS
fvwm-config [--help] [--version] [--info] [--prefix] [--exec-prefix] [--bindir] [--datadir] [--libexecdir] [--sysconfdir] [--mandir]
[--localedir] [--fvwm-moduledir] [--fvwm-datadir] [--fvwm-perllibdir] [--default-imagepath] [--default-userdir] [--fvwm-exe] [--supports]
[--supports-<feature>] [--is-final] [--is-stable] [--release-date]
DESCRIPTION
fvwm-config is a shell script that provides an information about the fvwm version, installation directories, built-in paths and supported
features.
OPTIONS
fvwm-config prints to the standard output in all options. Both short and long GNU-like option names may be used.
-h --help -?
prints the short usage
-v --version -V
prints the version
-i --info
prints the full info page
-P --prefix
prints the installation prefix
-E --exec-prefix
prints the installation exec-prefix
-B --bindir
prints the installation bindir
-D --datadir
prints the installation datadir
-L --libexecdir
prints the installation libexecdir
-S --sysconfdir
prints the installation sysconfdir
-M --mandir
prints the installation mandir
-O --localedir
prints the installation localedir
-m --fvwm-moduledir
prints FVWM_MODULEDIR, where the modules are installed
-d --fvwm-datadir
prints FVWM_DATADIR, where the system wide configs are installed
-p --fvwm-perllibdir
prints FVWM_PERLLIBDIR, where the perl library is installed
-I --default-imagepath
prints the built-in ImagePath
-U --default-userdir
prints the default FVWM_USERDIR, note: $HOME is not expanded
-e --fvwm-exe
prints the fvwm executable name (in bindir)
-s --supports
lists all supported features, one per line
--supports-<feature>
prints nothing, returns: 0 if the <feature> is supported, 100 if not, 200 if unknown. All or supported feature names may be found
using --info or --supports respectively.
--is-final
prints "yes" for final releases and "no" for cvs snapshots
--is-stable
prints "yes" for the stable branch and "no" otherwise
--release-date
prints the release date if the release is final
USAGE
Here are some real life usages.
Checks for xft support:
if fvwm-config --supports-xft;
then echo 1; else echo 0; fi
fvwm-themes package checks for the correct fvwm version installed using:
fvwm-config --version
and tries to use the same installation directories:
fvwm-config --bindir --mandir --fvwm-datadir
A way to find the full path to the fvwm executable:
echo `fvwm-config --bindir`/`fvwm-config --fvwm-exe`
A way to start modules in perl:
use lib `fvwm-config -p | tr -d '0`;
use FVWM::Module;
For a more human readable output, try:
fvwm-config --info
COPYING
fvwm-config is a part of fvwm package and distributed by the same terms, see GNU GPL.
AUTHOR
Mikhael Goikhman <migo@homemail.com>
3rd Berkeley Distribution 09 May 2010 (2.5.30) fvwm-config(1)