DSXchange

Hi, The dscmdexport command is a command line application and can be run unattended. But when I use the command for e.g. dscmdexport /H=R101 /O=1 dstage99 c:/scratch/project99.dsx, from the command line it pops up a window and says "The project99.dsx file already exists. Do u want to replace it...

HI,

Thanks!

I searched the forum. But I am unable to find it. There are more than 6000 entries found.

Plz help

Hi,

Is there any method to find out the jobs which are having User Defined SQL queries and the Queries from a Project. The jobs are using Oracle OCI9 Stage.

Thanks ArndW

I got the patch dsclient_xpsp2 by searching this forum.

Hi Arndw,

Will u please provide me more details of this patch.

Thanks for the reply. 1. A job, which populates 10000 of rows from Table1 to Table2. 2. If i stop the job or the job has been aborted after processing say 9000 rows, then all the updations done to the Table2 will be reverted back or Table2 will be in inconsistent state. If it is in inconsistent stat...

Hi,

In Windows XP, I am unable the view the properties window when I click the any stage of Seqeunce activities. When I double click or select properties from the short cut menu for any sequence activity, it wont show the properties window.

I tried using DS 7.1 and DS 7.5.1.

Hi, I have a job which populates a data from sequential file to a SQL table whose update action is "Clear table then insert rows". I have 10 records in the table and 5 records in the sequential file before running the job. If I run the job the 10 records are cleared from the table and 5 re...

Hi,

What is difference among the ODBC , DRS and Oracle OCI Stages in terms of performance.

Which is better to connect to Oracle 10g

Please advice

For connecting Oracle whether I need to edit the following three files.

dsenv
.odbc.oni
uvodbc.config

Now we are using MS SQL Server 2000 and DataStage 7.1. We are using DRS stage for to connect to SQL Server tables. We are going to upgrade to DS 7.5.1 and migrate to Oracle 10g. Whether we can continue to use the same DRS stage by changing the DBMS name from SQL Server to Oracle or we to replace all...

Hi,

Can we use DRS Stage of DataStage 7.5.1 to connect Oracle 10g?

Or we have to use only Oralce Stage to connect Oracle 10g in DS 7.5.1.

Hi, Consider the following design. Master_Seq Seq1 ---> Seq2 Seq1: Job01 ---> Job02 ---> Job03 Seq2: Job04 ---> Job05 ---> Job06 All the sequences are restartable with Run action. My requirement is like this : When I run Master_Seq, consider job02 is failed. After correcting the job, once again I wi...

Kumar, Reset if reqd then run for a job is not working. Master_Seq : BaseSeq1 ---(Executed Ok)---> BaseSeq2 -(Executed Ok)--> BaseSeq3 BaseSeq1: Job1 ---(Executed Ok) ---> Job2 --(Executed Ok)-> Job3 If I run the Master_Seq, let us suppose Job2 has got failed then BaseSeq1 and Master_Seq are getting...

Hi, We are using DataStage 7.5.1 1. Can we write a routine which compiles all the jobs present in a project. If yes, then please specify. 2. Consider the following scenario. a. We have a Master sequnce which contains a group of base sequnces which runs one after the other if they are successful. b. ...