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.
Search found 14 matches
- Thu Jun 14, 2012 7:54 am
- Forum: General
- Topic: Need to run a Seq withinn another
- Replies: 9
- Views: 4516
- Fri Jun 08, 2012 2:56 am
- Forum: General
- Topic: Firing query on UNIVERSE through UNIX script
- Replies: 17
- Views: 8824
- Wed Jun 06, 2012 12:36 am
- Forum: General
- Topic: Firing query on UNIVERSE through UNIX script
- Replies: 17
- Views: 8824
- Wed Jun 06, 2012 12:28 am
- Forum: General
- Topic: Firing query on UNIVERSE through UNIX script
- Replies: 17
- Views: 8824
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...
- Wed Jun 06, 2012 12:06 am
- Forum: General
- Topic: Firing query on UNIVERSE through UNIX script
- Replies: 17
- Views: 8824
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. ...
- Tue Jun 05, 2012 7:45 am
- Forum: General
- Topic: Firing query on UNIVERSE through UNIX script
- Replies: 17
- Views: 8824
- Tue Jun 05, 2012 5:54 am
- Forum: General
- Topic: How to find first occurance of numeric value in a string
- Replies: 13
- Views: 8228
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...
- Tue Jun 05, 2012 5:44 am
- Forum: General
- Topic: Firing query on UNIVERSE through UNIX script
- Replies: 17
- Views: 8824
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...
- Sun Jun 03, 2012 3:25 am
- Forum: General
- Topic: Firing query on UNIVERSE through UNIX script
- Replies: 17
- Views: 8824
Firing query on UNIVERSE through UNIX script
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.
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.
- Sun Oct 24, 2010 11:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Error generated while viewing the log
- Replies: 2
- Views: 3894
DataStage Error generated while viewing the log
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 ...
- Fri May 14, 2010 9:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removal of Special Character
- Replies: 9
- Views: 12723
- Wed May 12, 2010 10:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removal of Special Character
- Replies: 9
- Views: 12723
- Tue May 11, 2010 5:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removal of Special Character
- Replies: 9
- Views: 12723
Removal of Special Character
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
- Sat May 08, 2010 10:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removal of Special Character
- Replies: 9
- Views: 12723
Removal of Special Character
Can anybody tell how to remove special characters from a string in DataStage?