DSXchange

Why do you specify "without using Director"? It's by far the easiest way. The status of each and every job is in a separate table in the Repository. ... At present iam preparing this report manually it will takes 1 hr, but i want to make a job for preparing the report. Is there anyway for...

Hi, I have placed a job in a sequence. Under the 'Job Activity' options there is a Trigger tab. Under 'Expression', I have 4 options: Unconditional Otherwise OK (Conditional) Failed (Conditional) Warning (Conditional) UserStatus (Conditional) Custom (Conditional) My query is as follows: I have two ...

Hi, I have placed a job in a sequence. Under the 'Job Activity' options there is a Trigger tab. Under 'Expression', I have 4 options: Unconditional Otherwise OK (Conditional) Failed (Conditional) Warning (Conditional) UserStatus (Conditional) Custom (Conditional) My query is as follows: I have two ...

Hi, I have placed a job in a sequence. Under the 'Job Activity' options there is a Trigger tab. Under 'Expression', I have 4 options: Unconditional Otherwise OK (Conditional) Failed (Conditional) Warning (Conditional) UserStatus (Conditional) Custom (Conditional) My query is as follows: I have two ...

Just a thought .. Can't we use a custom sql with seperators for the 3 queries to be executed one after the other.

I have created a job parameter name "dnm". I need to use the parameter in a count query ...in the ODBC stage (Sql server 05). select count(deptno) from emp where dname = acct. I want to parameterizet the deptno like.. select count(deptno) from emp where dname = '#dnm#'; (even tried "...

1) Try using the Group as it works on 7.1 and earlier , you cannot send multiple e mails from 7.1 and earlier versions.
2) Some time if the jobs status files are scattered, the logs are not displayed in the Director. Try indexing through the ds commands for the project and run your job again.

:o Hi I suggest the following: 1. Check if you have the read permissions on the directory where you are creating the hashed file. 2. Check if you using the same path name for the directory. Sometimes a white space is all that is causing the error. 3. Before you run the job again try opening the file...

ray.wurlod wrote:Isn't that the old name for parallel jobs? ...

Thats Really funny .. Horkestra on the DataSTAGE

as pointed out by other DRS is DB independent and offers the flexibility of using with multiple db's.
Yes the OCI have a better way of handling the data structures if your source and target database is oracle.
Yes most of the common db have the plugins delivered with the Datastage tool.

Use two links. Chulett Lando had mentioend he did not want to use two seperate links and u gave him the suggestion of using two links ?? My suggestion of using the customized sql was based on the assumption that the users have a basic knowledge of working with DataStage. If he had asked about the d...

Hi, Do you have problems during run time or just in the view data? If it is only a view data problem I suggest you ignore it ... the view data is not reliable and tends to make problems. If it is in run time ... there is a fix from ascential support for this stage HTH, Amos Amos /jzparad The proble...

hi Can anyone suggest the optimum server cinfiguration required for running DataStage 7.5 on Windows. We are planning to run an approx of 1000 sequences/ server jobs which create about 250 hash files with an average of 5 columns in each file. We plan to use Dyanic RDBMS stage to read and write data ...

Hi I am getting this error when I am using the DsParameter files to pass the parameters and do the View Data. jobName.DRS_StageName: Unknown client library - $PROJDEF jobName.DRS_StageName.DSLink1: DSP.Open GCI $DSP.Open error -100. If I replace the parameters with the Actual DBName , UserName and P...

chulett wrote:Use two links.

You can use a customized sql to handle your insert/update statement.