I am currently running the following Korn shell script which works fine:
#!/usr/bin/ksh
count=`db2 -x "select count(*) from schema.tablename"`
echo "count"
I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
hi everyone, rookie scripter here. Under some time pressure here and hoping you can help. I've written a .csh script that needs to check a row count in an Oracle table, then do an IF-THEN check against that count. Two different select statements actually, one after another. If either of the two... (1 Reply)
I am working on this script, but hit a bump. Looking for a little help figuring out the last part:
open(MY_FILE, $ARGV) or die
$COUNTER = 1;
$LINE = <FILE>;
while ($LINE, <FILE>) {
# Adds leading zeros for numbers 1 digit long
if ($COUNTER<10){
print "000";
}
# Adds... (2 Replies)
Hi all,
what will be the code to compare count present in two seperate files
for e.g file (a) contains counts
100
and file (b) contains records
90
since both these files have differnt count so it will display count didnt match
and in case of success it display (5 Replies)
Hi all,
i have a list of files that contains some PC hostname, then i need to enumerate every hostname and check if there's a table with same name of the hosts in MySQL database XYZ.
I need this because have to decide automatically if i have to make a create table or a insert into an existent... (2 Replies)
I need a Shell script which take two inputs which are
1) main directory where it has to search and
2) pattern to search within main directory all files (.c and .h files)
It has to print number of pattern found in main directory & each sub directory.
main dir --> Total pattern found = 5
|... (3 Replies)
Hi Guys,
I am trying below condition .
We are using Informatica 9.5 and scheduling certain informatica mapping on set timings .But we are not sure whether the database source table are latest or not .Since its gets updated on daily basis and not sure when it completes.Can we write any unix/perl... (1 Reply)
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Dear team
I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids .
Currently i am using below query but this displays table name and counts for latest run.
select name ,CARD from... (0 Replies)
Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer:
<script>
$(function(){
$('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT SUSE
bogoupgrade
BOGOUPGRADE(1)BOGOUPGRADE(1)NAME
bogoupgrade - upgrades bogofilter database to current version
SYNOPSIS
bogoupgrade [-h] -d directory [-i input file] [-o output file] [-b path to bogoutil]
DESCRIPTION
bogoupgrade is a command to upgrade bogofilter's databases from an old format to the current format. Since the format of the database
changes once in a while, the utility is designed to make the upgrade easy.
OPTIONS
The -h option prints the help message and exits.
The -d specifies the directory with the wordlists for converting. This option is used when converting from multiple, separate wordlists
(spamlist.db and goodlist.db - containing spam and ham tokens, respectively) to a combined wordlist (wordlist.db) which contains both spam
and ham tokens.
The -i specifies the input file to be converted. It should be a text file containing message counts, and possibly data. If there is no data
in the text file, there should be a Berkeley DB file in the same directory as the text file which contains the data.
The -o specifies the output Berkeley DB file.
The -b gives the path to the bogoutil command. It defaults to 'bogoutil', in the hopes that your shell will find it.
UPGRADING
Follow these instructions to upgrade bogofilter's databases to the latest version.
1. Stop all instances of bogofilter. While the upgrade tools lock the database files, the upgrade may take a long time if you have a busy
site. Don't forget to stop cron jobs or daemons that fetch and process mail and could fire off bogofilter.
2. Backup your data. Let's assume that you said:
$ mv ~/.bogofilter ~/.bogofilter.safe
$ mkdir ~/.bogofilter
3. If your bogofilter version is less than 0.7, say:
$ bogoupgrade -i ~/.bogofilter.safe/goodlist -o ~/.bogofilter/goodlist.db
$ bogoupgrade -i ~/.bogofilter.safe/badlist -o ~/.bogofilter/spamlist.db
If your bogofilter version is 0.7 or greater, say:
$ bogoupgrade -i ~/.bogofilter.safe/hamlist.count -o ~/.bogofilter/goodlist.db
$ bogoupgrade -i ~/.bogofilter.safe/spamlist.count -o ~/.bogofilter/spamlist.db
4. Current versions of bogofilter use a combined wordlist that holds both spam and non-spam tokens. It is named wordlist.db. If you're
updating from a version older than 0.14.0 that has separate wordlists (named goodlist.db and spamlist.db), use:
$ bogoupgrade -d ~/.bogofilter.safe
5. Done. Restart any stopped daemons, cron tasks, etc.
AUTHOR
bogoupgrade was written by Gyepi Sam <gyepi@praxis-sw.com> and David Relson <relson@osagesoftware.com>.
For updates, see [1]the bogofilter project page.
SEE ALSO bogofilter(1), bogolexer(1), bogotune(1), bogoutil(1)REFERENCES
1. the bogofilter project page
http://bogofilter.sourceforge.net/
07/23/2007 BOGOUPGRADE(1)