Unable to pass value from .Shell script to .SQL file Post: 302942474

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to pass values from oracle sql plus to unix shell script

2. Shell Programming and Scripting

How to pass pl/sql table values to shell script

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...

3. Shell Programming and Scripting

How to pass arguments to SQL file passed in shell script?

Hi, I am using SYBASE database. in my script i am connecting to DB via using isql. isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL i am taking a ABC.sql file to use the queries written in it and storing the output in...

4. Shell Programming and Scripting

How to Pass the Output Values from the PL/SQL Procedure to Shell Script?

hi, Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable... Thanks in advance...

5. Shell Programming and Scripting

pass null value to sql script from korn shell script

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...

6. Shell Programming and Scripting

unable to pass value to user prompt from calling shell script

This is my script structure main script calls configure script which needs to be run as a different user and the configure script calls my application installation script. the application instruction script prompts the user for a directory which I need to pass from my main or configure script. ...

7. Post Here to Contact Site Administrators and Moderators

Unable to pass shell script parameter value to awk command in side the same script

Variable I have in my shell script diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff | awk -F'~' ''$2 == "$id"' {print $0}' > $new I could see value of $id is not passing to the awk...

8. Shell Programming and Scripting

Unable to pass shell script variable to awk command in same shell script

I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist. diff=$1$2.diff id=$2 new=new_$diff echo "My id is $1" echo "I want to sync for user account $id" ##awk command I am using is as below cat $diff | awk...

9. Shell Programming and Scripting

Unable to pass send command in shell script

I am trying to automate a testcase . I am installing some software and it waits for user input after displaying "Do you want to continue ? " I am trying to do this in shell scripting. #!/bin/bash #!/usr/bin/expect -f /usr/bin/expect << EOF spawn apt-get install openjdk-7-jdk expect "*Do you...

10. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

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 ....

LEARN ABOUT DEBIAN

dspam_maintenance

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)