Tuesday, May 27, 2008

This talks about the usage of 'dsjob' command in Datastage. I have develop one small script which will help in finding the job locations.
This script uses two parameters: 1.ProjectName 2.JobName
#!/bin/ksh
. $DSHOME/dsenv
proj=$1
jobname=$2
# You have to search where exactly your project is placed.
#In our case it is in below mentioned path
cd /data/projectlib/$proj
echo Location for the job $jobname is
$DSHOME/bin/uvsh "SELECT CATEGORY FROM DS_JOBS WHERE NAME = '$jobname';"

About Me

Pune, Maharashtra, India
Datastage Developer ;)