DSXchange

GetCommaDelimiParam($CMDW_AUTOMATION_FILE_ROOT:"/":$CMDW_POLLINGJOBCONTROL_FILE, 1, 2)

Could anybody kindly support explain what the expressiob above is for,which is one expression in user variable stage.

Many thanks in advance....

#! /bin/Ksh export DSHOME=`cat /.dshome` export PATH=$PATH:$DSHOME/bin proj_name=$1 job_name=$2 hash_num=null #job_name=`echo $2 | tr "[:lower:]" "[:upper:]"` echo Project_name: "$proj_name" echo Job name: $job_name if [ -f $DSHOME/dsenv ] then . $DSHOME/dsenv else echo...

Thanks for your comments,chulett!
A job which status is identified as "compiled" in Director is indicated :
Not running 99

after I run

dsjob -jobinfo ProjectName JobName


I do not think that it can prove that 99 means compiled.

What is your opinion?

I would think you'd be plenty safe using dsjob and checking for 99 as "compiled". What happens when you test that theory? Not running 99 indicates "Any other status" not only "compiled". So I would like to find a command or SQL to make sure that a job is in the "c...

Hello,everyone! As we know,we can see the job info especially the job status from the DataStage Director like this: Job_name Status Started On_date Last _ran ...... filter_string Compiled 04:01 AM 12/29/2008 ...... I would like to check whether the jobs are in the "compiled" status or not ...

Yes /datastage/dsadm/Ascential/DataStage/DSEngine is the home path for Datastage, the .odbc.ini file you are modifying is under this path,right... Now you need add approciate DSN entry in that file. [a] Driver=/datastage/dsadm/Ascential/DataStage/branded_odbc/lib/VMdb220.so Description=DataDirect 5....

Is there any error encountered,if so can you post the error information here, usually we just need add coresponding DSN entry in the .odbc.ini file under $DSHOME.... Hi All, My requriement is to connect to a DB2/400 (iSeries) & SQL Server sources with the Datastage server in AIX 5.3. and the tar...

Yeah,although I could not read the fulltext of comments posted by you,I can know you are supporting running dssh under project path other thant $DSHOME :) And in fact,few persons I know care under which folder the dssh is executed. I believe we can resolve my last question someday in future... As yo...

Hi ArndW, Thank you for input, the method mentioned does work,bu it is said it is not a good habit to run dssh/uvsh under other paths than $DSHOME, And I have achieved this by function calling,detailed as following: 。。。。。。。。。。。。。。。。 run_dssh() { a=$1 b=$2 cd $a dssh<<eof LOGTO $2 SELECT * FROM DS_JO...

dssh<<eof pterm case noinvert SELECT JOBNO FROM DS_JOBS WHERE NAME = 'Test'; QUIT eof Hi ArndW&ray, Thank you for your kindly inputs,and the script as above works,I have another question here,is there any way so as I have transfer the output of the Select query to one Unix variable or plain file...

Hi, I would like to realize one function retrieving the hash_num for one job using shellscript,the server is of AIX What I do now in the script file is 'hellp' is project name and 'Test' is the job name dssh<<eof logto hellp select JOBNO FROM DS_JOBS WHERE NAME ='Test' quit eof But it will take long...

thanks kumar, I tried as u said but still got the issue and finally I resolved the issue by recreating the .profile file and stoped and started the service. Now im able to connect to the ds server. Thanks to ray.wurlod and kumar. Thanks allot guys.. :) Hi Can you elaborate on how to recreate the .p...

ArndW wrote:Hailun - there is a version of PX that runs with windows. ...

Hi ArndW,

Then what kind of version is it ? Can you elaborate on this..

nitin_sharma2459 wrote:Hi,

How will I configure a parellel jobs in windows enviornment?

Thanks,
Nitin

Also,there is no parallel function under windows environment...

Update the .odbc.ini file loacated in $DSHOME thru adding the DSN with the correct Driver information,ip address,username&password and port num... Update the uvodbc.config file loacated at $DSHOME and each project directory,adding the new DSN name... Update the dsenv file....and execute this fil...