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 OPENDARWIN

slapd-passwd

SLAPD-PASSWD(5) 						File Formats Manual						   SLAPD-PASSWD(5)

NAME

       slapd-passwd - /etc/passwd backend to slapd

SYNOPSIS

       /etc/openldap/slapd.conf

DESCRIPTION

       The  PASSWD  backend  to slapd(8) serves up the user account information listed in the system passwd(5) file.  This backend is provided for
       demonstration purposes only.  The DN of each entry is "uid=<username>,<suffix>".  Note that non-base searches scan the  the  entire  passwd
       file, and are best suited for hosts with small passwd files.

CONFIGURATION

       This slapd.conf option applies to the PASSWD backend database.  That is, it must follow a "database passwd" line and come before any subse-
       quent "backend" or "database" lines.  Other database options are described in the slapd.conf(5) manual page.

       file <filename>
	      Specifies an alternate passwd file to use.  The default is /etc/passwd.

FILES

       /etc/openldap/slapd.conf
	      default slapd configuration file

       /etc/passwd
	      user account information

SEE ALSO

       slapd.conf(5), slapd(8), passwd(5).

OpenLDAP 2.1.X							    RELEASEDATE 						   SLAPD-PASSWD(5)