DSXchange

Hi Ravi, If you want to work with Oracle plugin the following things are required or set 1) Oracle client has to be installed where DataStage server is there. 2) Create the DSN in tns names.ora file where you need to specify Oracle server address. 3) Set the ORACLE_HOME environment variable in user ...

Hi Caig, I would always suggest that if you want to improve your job performance by speed set a proper configuration file i mean point each node in a config file to different location provided it has good disk space,this would speed up your job performance. Cheers, Rajeev. Hi, I wanted to sagregate ...

Hi Madhu, Set all the required environment variables in a file like APT_ORCHHOME,APT_CONFIG_FILE,PATH,LD_LIBRARY_PATH(depending on your unix flavour),ODBCINI,DSEngine then go to your project directory directory to your job directory which is named as RT_SC[xxx] which you can view from your job direc...

Hi Prabhu, Just go to your Ascential.media/DataStage Server directory in your DataStage 751A setup directory and run the setup.exe file.This would install your DataStage server.Check for the Ascential services from your control panel if they haven't been started after installation,start them and the...

Hi Madhu, Its a simple problem the .o or .so file is not getting created when your transformer osh script is being ran which is necessary for the osh script of your job to run.To avoid the .o file failure error run it from osh and make it sure to include your transformer path in the PATH and LD_LIBR...

Hi Prabhaut, If you want to run only server jobs just go for the installation of DataStage Engine on windows as per ur required thing.And regarding the statement as u said "We can only complie jobs in 7.x in windows edition but to run we have to run it in unix" it is not correct.To run a p...

Hi , Just set the APT_ORCHHOME,APT_CONFIG_FILE,LD_LIBRARY_PATH,DSHOME,PATH in a file and execute it.After that type ORCHADMIN check on the command prompt to see that osh works or not.Then type orchadmin rm <dataset name>.This will do ur job for deleting the dataset but as you said even the dataset m...

Hi DsPandits, I was trying to remove the files created by using the datasets using the dataset management utility.But the mail control file is removed ,but the other files which are created along with it are not being removed. We are running our parallel jobs in 4 nodes..So,for each node 3 files ar...

Hi Chits, In the scenario you said transformations/calculations is not possible as the columns pass only during runtime from schema file and the osh code gets generated when you compile the job and that osh code is being ran when you run the job.If you want to do that then you have to load the colum...

Hi Srinivas, Parallel jobs can only be run on unix environments as the job which you design converts into the osh code when it is being ran.Osh is a shell in unix named orchestrate which creates the job in a single statement. Cheers, Rajeev. Hi, I have installed DataStage Ver 6.0 on Win 2000 profess...

Hi Chits, Its something like this schema file is used to import metadata into the stage during runtime.So for this you need to check runtime column propagation in the columns tab.To avail this option in your columns tab go to DataStage Administrator and check Runtime column propagation.Now when you ...