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

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 SUSE

dialtest

DIALTEST(8C)															      DIALTEST(8C)

NAME

       dialtest - HylaFAX dial string processing rules test program

SYNOPSIS

       /usr/sbin/dialtest [ options ] dialrules

DESCRIPTION

       dialtest  is  an  interactive  program for the testing and development of dial string processing rules used by HylaFAX.	dialtest reads the
       file of rules specified on the command line and then prompts for a dial string.	For each string typed in, dialtest prints  the	result	of
       applying  the  canonicalization	and dial-string preparation rule sets.	A rule set whose name is setname can be specified by typing ``set-
       name(string)''; for example, ``CanonicalName(+1.415.965.7824)''.

       Note that dialtest reads the rules file only when it is initially started up.  This means that dialtest must be restarted for it  to  apply
       changes to a rules file.

OPTIONS

       -a code	 Use code as the value of AreaCode in the rules file.  The default area code is ``415''.

       -c code	 Use code as the value of CountryCode in the rules file.  The default country code is ``1''.

       -i prefix Use prefix as the value of InternationalPrefix in the rules file.  The default international dialing prefix is ``011''.

       -l prefix Use prefix as the value of LongDistancePrefix in the rules file.  The default long distance dialing prefix is ``1''.

       -q	 Be quiet, suppressing most all output except for the actual results.  This is useful for using dialtest in an automated fashion.

       -v	 Print	each  input line before displaying the results of applying the dial string rules to the input string.  This can be useful,
		 for example, in shell scripts.

SEE ALSO

       dialrules(5F)

								   March 3, 1995						      DIALTEST(8C)