DSXchange

Hi I am using the following dssearch CLI command dssearch -ljobs -uses -recursive <project> <master_sequence> which will list all the jobs/sequences which underline this sequence recursiely. But it is not listing completely in some cases, I have seen so far. For some particular master_sequences, it ...

Hi Chullett I mean to say that the hash files are having similar structure but not same. What I wanted to explore was i. Editing the dsx file that was generated from the export of the job... ii. Doing a direct insert on the UV tables underlined the DataStage Engine. Any suggetion could help me... Th...

Hi We need to develop a job which does lookup to multiple hash files (around 20-30) and loads it to a table. Currently using desinger developing these jobs taking more time. Is there any way other than using designer, can we do the same design work which would be faster like writing a code? FYI: All...

Thanks Chullet

Hi In our shared DS Server on linux box..dsenv file contains both ORACLE_HOME and TNS_ADMIN variables being exported. The TNS_ADMIN pointing to unavailable directory. So..when I do Plugin metadata import for table definition..It is not showing any DataSourceNames.... But when I design a job and spec...

Ray...

This is manual option.. I want to automate this.. any idea on that

Thanks
Sai

I am not calling job2 from job1 or vice versa.

My main intention is to use the value in job2 that is modified by job1...
Is this possible in DataStage?

Thanks
Sai

I am going through DataStage CLI interface..with which I think I can do this... But can you please tell me how to get the log entries for current run of a particular job.... I know that there is a CLI command for showing the log entries with dsjob -logsum option. But we have to set the maximum numbe...

Hi Normally for a project,it contains a master_sequence, underlined to it multiple sequences in a tree structured format and at leaf..there would be jobs... In this format....If any job aborts..I would like to abort the entire sequence with the proper message that should be mailed to me.. The messag...

Hi

By using of environment variables, can we change the values in one job and use those changed values in other job...like the way global variables in languages?

Thanks
Sai

Thanks Ray....

Hi How would I use the output of Unix command (for example, wc -l filename.txt) in the job? I tried using the following options to do this work 1. We can only call the unix command in before/after job.. in which case, we cant use the return value from the output of this command... 2. One more way is...

I would like to know whether only dstage or dsadm group users can access the DataStage or
Any person whose group is given role as "DataStage developer" in administrator can access?

Thanks
Sai

Hi We have installed DS 7.5.2 on Linux box. Created a project "DSPractice". Defaultly, all the unix groups are having equal role, i.e. DataStage developer. A user "x" with group "users" is having "DataStage developer" role is not able to open the job from mana...

#!/bin/sh #################################################################### # # dsenv - DataStage environment file # # Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved # This is unpublished proprietary source code of Ascential Software Corporation # The copyright not...