06-12-2011
passing parameters from a script to a datastage job
We have a requirement as follows.
We have created a datastage job that will be doing the select operation from table (select query from a table).
The datastage job is being invoked by a unix shell script(ksh).
We are passing the "table name (STUD_DETAILS)" and a "where clause condition (ADDRESS IS NOT NULL) " as a parameter to the job.
If these parameters are passed to the datastage job, it will form a query as follows.
"select stud_name, join_year, roll_no from STUD_DETAILS where branch = 'CSE' AND ADDRESS IS NOT NULL;"
We have written the unix shell script as follows.
function abc
{
tblname=$1
cdntion=$2
}
..
..
..
in main function we are calling the function abc
x="STUD_DETAILS"
y="AND ADDRESS IS NOT NULL"
.. calling the function abc.
abc (x,y)
If we pass the parameter like this...
tblname is having STUD_DETAILS
and cdntion is having AND
we are expecting the cdntion to have "AND ADDRESS IS NOT NULL". The text "ADDRESS IS NOT NULL" is not being passed to the datastage job.
The script will be passing only 2 parm.
parm1 = table name
parm2 = where clause condition...... need to send the whole string (AND ADDRESS IS NOT NULL).
Can anyone help me to fix this issue.
Thanks
Krishnakanth Manivannan
Software Engineer
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have 2 scripts: script1 and script2
Script1 passes 4 parameters to script2 as follows
#script1
code
...
...
script2 $var1 $var2 $var3 $var4
Script2 uses the export command to know to expect these values
#script2
export $1 $2 $3 $4
code
...
...
The problem that I am having is... (1 Reply)
Discussion started by: eliguy
1 Replies
2. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
3. Shell Programming and Scripting
Hi
I have a question.
In the FTP script if we are passing all the required value like Hostname, username, password, Action(put or get), Filename, & mode(ascii or binary) through parameters then we have to pass these in the exact orders in which they are taken like if we defined Username=$2... (2 Replies)
Discussion started by: sourabhshakya
2 Replies
4. Shell Programming and Scripting
I am using grep to capture date from a file .
Since i need to use the shell script for different dates ,is it possible to pass the date parameter to the shell script
the Script is as below
grep -E "08 Aug 2008|2008-08-08"* somefile.txt>test.txt
The above script file greps the... (1 Reply)
Discussion started by: sud.tech
1 Replies
5. Shell Programming and Scripting
i have this basic piece of code that i am trying to debug to accept input parameter to be able to display a directory listing of files.
cd /u02/app/eatv/dev/out
CURDIR=`pwd`
echo directory listing of $CURDIR
echo
if ; then
ls -latr
else
ls -latr $1
fi
basically if the script... (9 Replies)
Discussion started by: wtolentino
9 Replies
6. Shell Programming and Scripting
I have a job script that runs with input parms from the command line.
job.sh -p parm1_parm2_parm3_parm4_file_1.dat
The parms are separated by _
The last parm is a file name and can have an _ in the name.
I currently use the following commands to extract the parms
parm1=`eval echo... (3 Replies)
Discussion started by: jclanc8
3 Replies
7. Shell Programming and Scripting
how can i make a script to run only when parameters are given,
if parameters are not given it should through an error , saying "please enter a parameter"
for ex: i want a find command to run only when the parameters are given (4 Replies)
Discussion started by: knip
4 Replies
8. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
9. Shell Programming and Scripting
Not a good post. (1 Reply)
Discussion started by: bash_in_my_head
1 Replies
10. UNIX for Beginners Questions & Answers
I am trying to compile the datastage jobs using the Execute Command stage in datastage 11 or any Routines if possible. My datastage is on Unix machine.
So, How can I Compile a datastage job in UNIX from command line or any Routines.
Please help me in doing so.
Thank you. (1 Reply)
Discussion started by: elena jessi
1 Replies
LEARN ABOUT SUNOS
mkcover
MKCOVER(8) System Manager's Manual MKCOVER(8)
NAME
mkcover - HylaFAX continuation cover page generation command
SYNOPSIS
/var/spool/hylafax/bin/mkcover qfile template result
DESCRIPTION
bin/mkcover is the command invoked by the facsimile server when a continuation cover page is required for an outbound job that is about to
be retried. It generates a single POSTSCRIPT(R) page that is imaged according to the remote capabilities and transmitted as the cover
page. The arguments are:
qfile the job description file for the outbound job.
template the cover page template file, as used by the faxcover(1) program.
result the filename where the resultant POSTSCRIPT document should be written.
The default mkcover command is a shell script that uses awk(1) to parse the job description file and generate the cover page document. The
template file may be optionally compressed with compress(1), pack(1), or gzip(1); the filename suffix is used to decide whether or not the
template file contains compressed data.
SEE ALSO
faxq(8), hylafax-config(5), sendq(5)
June 20, 1994 MKCOVER(8)