10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
2. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
3. Shell Programming and Scripting
Hello,
i`m looking for some way to add to some date an partial number of months, for example to 2015y 02m 27d + 2,54m
i need to write this script in php or bash or sh or mysql or perl in normal time o unix time
i`m asking or there are any simple way to add partial number of month to some... (14 Replies)
Discussion started by: bacarrdy
14 Replies
4. Shell Programming and Scripting
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies
5. Shell Programming and Scripting
Hi Guys,
Can someone please help me on adding/inserting a variable date to an sql scipt? Basically I want to assign a 7 days date range. As shown below..
#!/usr/bin/perl
use strict;
use Env qw(ORACLE_HOME);
my $SQLPLUS='/opt/oracle/product/10.1.0/db_1/bin/sqlplus -S... (1 Reply)
Discussion started by: pinpe
1 Replies
6. UNIX for Advanced & Expert Users
Hi,
I am unable to use parameter in sql script passed from unix script.
my sql script CREATE_SBI_LIST_GROUP.sql is like this -
-------------------------------
SELECT
SDS.ID "SO_ID",
SDS.SO a1,
sgp.sga__code SGA_CODE,
FROM
sga sga,sales_genl_provision sgp , comm_product_condn cpc... (2 Replies)
Discussion started by: apskaushik
2 Replies
7. Shell Programming and Scripting
Hi Guys,
I like to pass a variable to a sql file in a unix script..
I tried a below code..
var=200903
db2 -vf test.sql 200903
test.sql is as below.
select * from db2.users where quarter = $1;
Please tell me where i go wrong..
Thanks in advance,
Magesh (2 Replies)
Discussion started by: mac4rfree
2 Replies
8. Shell Programming and Scripting
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies
9. Shell Programming and Scripting
Hi all, I have a shell script which invoke a sql script using command
db2 -tf /home/me/db_housekeep.sql -z /home/me/db_housekeep.log
however, this mentioned sql script requires several input arguments, I wonder if one can pass variables from shell script to sql script? thanks! (0 Replies)
Discussion started by: mpang_
0 Replies
10. Shell Programming and Scripting
I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time.
## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies
dspam_maintenance(1) User Commands dspam_maintenance(1)
NAME
dspam_maintenance - remove old signatures and unimportant tokens from the DSPAM storage backend
SYNOPSIS
dspam_maintenance [--profile=PROFILE] [--logdays=no_of_days] [--signatures=no_of_days] [--neutral=no_of_days] [--unused=no_of_days]
[--hapaxes=no_of_days] [--hits1s=no_of_days] [--hits1i=no_of_days] [--without-sql-purge] [--with-sql-automatization] [--with-sql-autoup-
date] [--purgescriptdir=directory] [--with-all-drivers] [--verbose]
DESCRIPTION
dspam_maintenance is used to remove old signatures/tokens and unimportant tokens from the DSPAM storage backend and purge old log entries
in user and system logs.
This script can be called from the command line or run from within cron. Either add a line in your crontab or add this script in your
cron.{hourly,daily,weekly,monthly}. Running this script every hour might not be the best idea but it's your decision if you want to do so.
OPTIONS
--profile=PROFILE
Specify a storage profile from dspam.conf. The storage profile selected will be used for all database connectivity.
NOTE: See dspam.conf for more information.
--logdays=no_of_days
All log entries older than no_of_days days will be removed.
NOTE: Default is 31 days. (for more info: man dspam_logrotate)
--signatures=no_of_days
All signatures older than no_of_daysdays will be removed.
NOTE: Default value is set by the PurgeSignatures option in dspam.conf, if this option is not set, the default value is 14 days.
This option is only used for the Hash driver.
--neutral=no_of_days
Deletes all tokens from the target users database whose probability is between 0.35 and 0.65 (fairly neutral, useless data).
NOTE: Default value is set by the PurgeNeutral option in dspam.conf, if this option is not set, the default value is 90 days.
--unused=no_of_days
Remove stale tokens which have not been used for a long period of time.
NOTE: Default value is set by the PurgeUnused option in dspam.conf, if this option is not set, the default value is 90 days.
--hapaxes=no_of_days
Remove tokens with a total hit count below 5 (which will be assigned a hapaxial value by DSPAM).
NOTE: Default value is set by the PurgeHapaxes option in dspam.conf, if this option is not set, the default value is 30 days.
--hits1s=no_of_days
Remove tokens with a single SPAM hit.
NOTE: Default value is set by the PurgeHits1S option in dspam.conf, if this option is not set, the default value is 15 days.
--hits1i=no_of_days
Remove tokens with a single INNOCENT hit.
NOTE: Default value is set by the PurgeHits1I option in dspam.conf, if this option is not set, the default value is 15 days.
--without-sql-purge
Do not use SQL based purging. Only run dspam_clean.
NOTE: Default is off (aka: use SQL based purging).
--with-sql-optimization
Run VACUUM (for PostgreSQL/SQLite) and/or OPTIMIZE (for MySQL).
NOTE: Default is off (aka: do not use optimizations).
--with-sql-autoupdate
Run SQL based purging with purge day values passed to dspam_maintenance.
NOTE: Default is off (aka: do not attempt to modify SQL instructions).
--purgescriptdir=directory
Space separated list of directories where to search for SQL files used for the SQL based purging.
--with-all-drivers
Process all installed storage drivers (not just the active driver).
NOTE: Default is true (aka: process all installed drivers).
--verbose
Verbose output while running maintenance script.
EXIT VALUE
0 Operation was successful.
other Operation resulted in an error. Run the script with --verbose to get more information about error.
COPYRIGHT
Copyright (C) 2002-2010 DSPAM Project
All rights reserved.
For more information, see http://dspam.sourceforge.net.
SEE ALSO
dspam(1), dspam_admin(1), dspam_clean(1), dspam_crc(1), dspam_dump(1), dspam_logrotate(1), dspam_merge(1), dspam_stats(1), dspam_train(1)
dspam_maintenance Apr 26, 2010 dspam_maintenance(1)