How to pass two word parameter Post: 302686795

Sponsored Content

Top Forums Shell Programming and Scripting How to pass two word parameter Post 302686795 by Corona688 on Wednesday 15th of August 2012 11:51:17 AM

08-15-2012

Registered User

You should quote the variables in question.

Code:

#!/usr/bin/ksh
# run_convert_pdm.ksh
#
# Using SQL*Plus anaymous block to call a stored procedure
#
#
# This script is called with 8 params: userid, password, database, pdm db link, owner, div, dept
# access to TSS target - (user passwd sid) must be provided.
USER="$1"; export USER
PASSWD="$2"; export PASSWD
SID="$3"; export SID
PDM_DB="$4"; export PDM_DB
OWNER="$5"; export OWNER
DIV="$6"; export DIV
DEPT="$7"; export DEPT
STYLE="$8"; export STYLE
if [ -z "$8" ]; then
echo " **ERROR** $0 - 8 arguments not provided!"
echo " Usage: $0 userid, password, database, pdm db link, owner, div, dept, style"
exit 1 # failure
fi
rm ./run_convert_pdm_"${DEPT}".log
echo "**************** $(date +%c) Summary ${DEPT} ****************" >> ./run_convert_pdm_"${DEPT}".log
$ORACLE_HOME/bin/sqlplus ${USER}/${PASSWD}@${SID} >>./run_convert_pdm_"${DEPT}".log <<EOC
whenever sqlerror exit 1
execute CNVT_TP_SUMMARY('${PDM_DB}', '${OWNER}','${DIV}','${DEPT}','${STYLE}');
EOC
if [ $? -eq 1 ]; then
echo "Error in the stored procedure CNVT_TP_SUMMARY";exit 1
fi
exit 0

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pass Parameter to Another Script

I have a piece of code that I do not want to continuously repeat. I want to call script2 from script1 and pass a parameter. Here is an example: Script1: ....... nohup ./Script2 PARAMETER ....... Script2: if # Checks if any params. then echo "No parameters passed to function." ...

2. Shell Programming and Scripting

Pass parameter into script

I would like to write a scirpt a.sh that it first checks the first parameter of the input. If it fulfill some condition ,then run an executable program b by using all the parameter. ie. > ./a.sh 10 20 30 40 50 Then a.sh first checks the first parameter, 10, if it mathes the requirement, then...

3. Shell Programming and Scripting

How to pass a parameter

Hi all, How to pass a parameter from a oracle pl/sql procedure parameter to shell environment and use it?

4. UNIX for Dummies Questions & Answers

How to pass parameter to subroutine

I have something like cp -p <dir>filename1.dat <dir2>filename1.dat there are many other operations in it I mean that filename1.dat will keep on changing I need to write a subroutine so that i can pass filename1 or 2 or 3 .dat as parameter Thanking you in advance Any help wuld be appreciated

5. Shell Programming and Scripting

pass parameter to function

HI all I have a code like ############################################## minyear() { curryear=$1 echo $curryear } ##Main Program ## minyear exit ####### when i execute "sh scriptname 2005" output should be like 2005 but the output is blank. I guess i need to pass parameter to...

6. UNIX for Dummies Questions & Answers

How to pass the parameter value to a... ?

Hello I have a simple code like this one: #!/bin/ksh VER=$1 cat /usr/text | while read line do echo $line done Let's say $1=1.0.0 and the contents of text is: abcd.cfg asdf I would like the output to be like this abcd1.0.0.cfg asdf1.0.0 I am thinking of passing the...

7. Shell Programming and Scripting

pass parameter to SED

My script(ksh) works fine for --------------------------------------------------- sed -n '28,31p' ${l_name} >> ${LOG_DIR}/Email.txt --------------------------------------------------- But I wand to pass parrmeter to this syntax I did the following things ...

8. Shell Programming and Scripting

Pass parameter

Hi, I have following for loop , please let me know how to get ${TXP_EXT_TABLE_${i}_SQL} parameter with 1DAY and 7DAY values. for i in 1DAY 7DAY do ${NZSQL_DIR}/nzsql -h ${HOST} -time -v ON_ERROR_STOP=1 -f ${SQL_DIR}/${TXP_EXT_TABLE_${i}_SQL} > ${TMP_LOG_FILE} 2>&1 done ...

9. Shell Programming and Scripting

How to pass parameter to bteq?

I am using below code to connect terdata and getting the query result in a file.Now i want to use same code for different tables,plz tell me how to pass table name as parameter.i tried using as below code but not working. bteq < /download/viv/dev/ops/Scripts/ter.sh FLTORGTKR_ORG_etc.. ...

LEARN ABOUT SUSE

passwd.nntp

PASSWD.NNTP(5)						    InterNetNews Documentation						    PASSWD.NNTP(5)

NAME

       passwd.nntp - Passwords for connecting to remote NNTP servers

DESCRIPTION

       The file pathetc/passwd.nntp contains host / name / password triplets for use when authenticating client programs to NNTP servers.  This
       file is normally interpreted by NNTPsendpassword() in libinn(3).  Blank lines and lines beginning with a number sign ("#") are ignored.
       All other lines should consist of three or four fields separated by colons:

	   host:name:password
	   host:name:password:style

       The first field is the name of a host, and is matched in a case-insensitive manner.  (No detailed matching, such as comparing IP addresses,
       is done.)

       The second field is a user name, and the third is a password.  If either the username or password is empty, then that portion of the
       authentication will not occur.  (For example, a server may require only a username, in which case the password is not necessary.  Note that
       a username is mandatory with AUTHINFO USER/PASS.)

       The optional fourth field specifies the type of authentication to use.  At present, the only recognized "authentication style" is
       "authinfo"; this is also the default.  It means that AUTHINFO USER/PASS commands are used to authenticate to the remote host.  (These NNTP
       commands are described in RFC 4643.)

       For example:

	   ##  UUNET needs a password, MIT doesn't.
	   mit.edu:bbn::authinfo
	   uunet.uu.net:bbn:yoyoma:authinfo

       This file should not be world-readable.

HISTORY

       Written by Rich $alz <rsalz@uunet.uu.net> for InterNetNews.

       $Id: passwd.nntp.pod 8822 2009-11-20 17:34:15Z iulius $

SEE ALSO

       inn.conf(5), innd(8), libinn(3).

INN 2.5.2							    2010-02-08							    PASSWD.NNTP(5)