DSXchange

Hi,

Just simple do following steps in command prompt and prepare a UNIX script so that it gets automated:
1)cd `cat /.dshome`
2)cd bin
3)dsjob -report project_name job1

The output of step 3 will give you the result.

Hi friends, As told you before, when I fire dssh command in bin directory of DataStage Engine I use to get following output: bash-2.05b$ bash-2.05b$ dssh This directory is not set up for DataStage. Would you like to set it up (Y/N)? Shall I set it up by pressing "Y". Actually I don't know ...

zulfi123786 wrote:dssh should ideally be in the bin directory of DSEngine

yes zulfi

It is in BIN directory but it is a softlink which is pointing to ....DSEngine/bin/uvsh

Hi Team, I have found out one more thing. This might help. I went into the bin directory of DSEngine. Please find the directory structure, you can find dssh: -rwxr-x--x 1 twdsadmp twdsadmp 1379 Oct 14 2008 pi.t1conv -rwxr-x--x 1 twdsadmp twdsadmp 3265 Oct 14 2008 pi.prepisys -rwxr-x--x 1 twdsadmp tw...

Hi Vamsi, Thanks for your participation. Actually my requirement is not to find out total number of jobs in a project, but it is to find out the job number which is associated with a Job. Chulett, I have tried to find out the path where dssh might be stored but as displayed below it is not present. ...

Thanks for your reply.

When I execute "dssh" in Project directory, I get following error:

"bash: dssh: command not found"

What could be the reason?

A simple solution which I can suggest but it is in Server Job: Let Say: The column name in which you have to perform this logic is X. In transformer of Server Job you can write the below mentioned transformation: Oconv(X,'MCN')[1,1] Above written Oconv function will give all the numerals as a output...

Hi Zulfi, Thanks for your reply. I have tried this but it is not working. I will give you one example: Whenever we have find out the job number of a job , we either fire a query on administrator or do the same through command prompt. We care doing this through command prompt by just following the be...

Hi Folks,

Please help me with one issue. I want to know how to execute a query on DS_JOBS through UNIX script.

I know the steps like:
1)LOGTO Project_name
2)Write a query: SELECT COUNT(*) FROM DS_JOBS

But I need to automate this process through UNIX script.

Please suggest.

Hi all, I am facing one issue while loading the data in the oracle table with the help of server jobs. Number of records are 113 Millions. The job is simple. Its design is like extraction from DB2 then transformer and finally loading stage to load data in oracle database. I have used ODBC stage for ...

I am given examples of Non Aplhanumeric Codes. Kindly let me know if their is any general logic.

Special characters are like:

!@#$%^&*()_-+={}[]|\:";'?><,./~`

In simple words any non Alphanumeric characters are special characters

Yes I do have permission of the owner. This was the smal requirement to do AphaNumeric comparision on two columns. So thats why I was trying to remove special characters from the column

Can anybody tell how to remove special characters from a string in DataStage?