DSXchange

Hi Sasi, When you want to kill a process/job first you have to find out the process ID which are currently running on datastage server I would like to prefer to connect to your server via telnet with your ID and then use ps -ef command which gives the current processes which are running on your serv...

I am also facing same problem while connecting to developer.net from Ascential site

Acually I want the main difference between replace all the rows with existing rows and clear rows and inserting new rows what is the b/g process in these two update actions? Why they are used two things for smae action? Why the ODBC stage update actions are different , OCI stage update actions are d...

Hi All We are using arraysize as 5000 in source, Why it is recommended Is there any reason for this? In target we are using arraysize as 32363 actually I am asking what is the background logic here. why these values are recommended? I thought as this as the buffersize, Datastage captures data upto t...

I mean job has been locked thatsy first i want to unlock and clear status file and all those things
please let me know how to do those things
first which one I have to do?
from client(director/Administrato) or unix server I have to cleanup?
which is the better method to unlock?

How to cleanup unwanted hash files
I have hash fiels in the repostory and also in the differ path in the server itself
I want to remoove those hash files
please let me know how to do those.

How to clean up the particular job in the project

How to do unlocking the routines when i am importing some jobs to the server, connectionwith server broken to the server then usually what happens I again imported those but some jobs are not working properly what is the basic reason behind this I had to import againe please suggest me why these thi...

Thaks Ray,

We are using encrypting passwords only

Thankx ArndW

I will go through ur advice.

A simple job to read the .dsx file, do an EREPLACE() of your {search} and {replace} texts in a simple transform and write it to an output file. It shouldn't take more than an hour to write this job and debug it.

thanks for this IDea

ps -ef |grep phantom

actually what is phantom and what it means why thisis used for identify dsjobs PID s and locks

Hi Thx for your responce especially for srinivasulu and arndw but I need help to write a shell script to change the multiplea find/replace things suppose i want to change src (dsn,UID,pwd) ,trg (dsn,UID,pwd) while it is kick-off, for this shell script Just i gave only parameter values as arguments t...

To be deployed for use DataStage code promotions. project will have a set of text files to run against code coming from Development: .dsx file Here I want to change some pareamters form Development to QA/Test/production I want to Find a utility to handle multiple find and replace combinations in .ds...

Hi srini9, where u r giving the data month year and no coloumns in parameters window? or in transformer stage? I think u have to give the date format as yyyy-mm-dd format as a paramter whereever it might be u can use this parameter (in jobcontrol routines or somewhere else) Thanks & with Regards...