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

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 CENTOS

mail::spamassassin::plugin::replacetags

Mail::SpamAssassin::Plugin::ReplaceTags(3)		User Contributed Perl Documentation		Mail::SpamAssassin::Plugin::ReplaceTags(3)

NAME

       Mail::SpamAssassin::Plugin::ReplaceTags - tags for SpamAssassin rules

       The plugin allows rules to contain regular expression tags to be used in regular expression rules.  The tags make it much easier to
       maintain complicated rules.

       Warning: This plugin relies on data structures specific to this version of SpamAssasin; it is not guaranteed to work with other versions of
       SpamAssassin.

SYNOPSIS

	 loadplugin    Mail::SpamAssassin::Plugin::ReplaceTags

	 replace_start <
	 replace_end   >

	 replace_tag   A       [a@]
	 replace_tag   G       [gk]
	 replace_tag   I       [il|!1y?xccxcdxcexcfxecxedxeexef]
	 replace_tag   R       [r3]
	 replace_tag   V       (?:[vu]|\/)
	 replace_tag   SP      [s~_-]

	 body	       VIAGRA_OBFU     /(?!viagra)<V>+<SP>*<I>+<SP>*<A>+<SP>*<G>+<SP>*<R>+<SP>*<A>+/i
	 describe      VIAGRA_OBFU     Attempt to obfuscate "viagra"

	 replace_rules VIAGRA_OBFU

RULE DEFINITIONS AND PRIVILEGED SETTINGS

       replace_tag tagname expression
	   Assign a valid regular expression to tagname.

	   Note: It is not recommended to put quantifiers inside the tag, it's better to put them inside the rule itself for greater flexibility.

       replace_pre tagname expression
	   Assign a valid regular expression to tagname.  The expression will be placed before each tag that is replaced.

       replace_inter tagname expression
	   Assign a valid regular expression to tagname.  The expression will be placed between each two immediately adjacent tags that are
	   replaced.

       replace_post tagname expression
	   Assign a valid regular expression to tagname.  The expression will be placed after each tag that is replaced.

       replace_rules list_of_tests
	   Specify a list of symbolic test names (separated by whitespace) of tests which should be modified using replacement tags.  Only simple
	   regular expression body, header, uri, full, rawbody tests are supported.

       replace_start string
       replace_end string
	   String(s) which indicate the start and end of a tag inside a rule.  Only tags enclosed by the start and end strings are found and
	   replaced.

perl v5.16.3							    2011-06-06				Mail::SpamAssassin::Plugin::ReplaceTags(3)