DSXchange

Hi, I have a data stage job which reads from a SQL server DB and writes to oracle DB. Datastage flow for this contains OLEDB stage -> Transformer stage -> Oracle stage One of the input column name is 'File#'. I am able to load the table definition in columns tab. But when i use this column in deriva...

Thanks,

Setting NLS_LANG to AMERICAN_AMERICA.AL32UTF8 did the trick. Even though we have database set up in WE8ISO8859P1.

What is the exact server version on each system (for example 7.5.1.r2d2)

Both of the Servers are running DataStage 7.5.1.A

Hi, We are facing some discrepancies in dsx export of same jobs exported from two similar projects. We develop jobs on one system, export it as dsx and import & execute them on another system. Datastage servers are different and located on different machines. DataStage Projects on these differen...

Thanks Ray & Craig.

I am going ahead with 'log warnings after activities that finish with status other than OK'.

Hi, We have a master sequence which calls a number of jobs as well as sequences. If a job directly called from master sequence fails, we see its status as 3[Aborted] in Director log of master sequence. But if a job called from a child sequence fails, we see status for that sequence as success in our...

Hi, In our jobs, we are using after-job subroutine to call a sql file which in turns executes a number of Stored Procedures. When we run the jobs individually it works fine, but when we run the jobs through a DataStage sequence, next job is triggered even when the oracle stored procedures of previou...

Hi Ray,

yes, I can use the env variable name. But we already close to 100jobs, each with six "job level" parameters defined. And instead of changing the oracle stages in the jobs, we want to just pass project level parameters to the job paramteres, which are already being used!

The issue is how to pass project level parameter value to job level parameter. I defined prjTgtDb at project level and imported that to job paramter as $prjTgtDb with value as $PROJDEF. This is fine.

But I want to get the value $prjTgtDb to my job level parameter - jpTgtDb!

We have tried it. It worked fine for us in the past, but jobs were simple and we used only common data types - number & varchar.

Hi, We have about a 100 jobs each having 6 parameters for database credentials(3 for source, 3 for target), which we use in oracle stages inside the job. As of now we need to modify the parameters at run time in jobs or in different sequences which call these jobs. But we wish to set these parameter...

Although they always say "turn off anti-virus software before installing" I've never had to do that, but perhaps in your case that might be causing an issue. DS install on XP Pro has worked for me. Before you re-try, make sure to clean out directories and also remove any registry entries ...

Why not simply ask your team mates what they did to get it successfully installed? Or as Arnd noted, state the actual problem that you had. Hi, It doesnot show any error. I can see only the process started from Task manager but Installation progress is not viewable. I waited for 5-6 hrs but install...

Good catch, Craig; I missed that. While some have had success on XP Pro, it is not a supported platform. I know of nobody who has had success running the server on XP Home. Hi, The machine is WindowsXP Professional Edition. My team mates have successfully installed both server and client on the m/c...

What services do you mean? The services present under Administartive tools > Services on Windows XP. Like firewall service or .NET service etc. Please let me know the prerequistes if any for installing server/client. The following is the conf of them/c i am trying to install server on:- WindowsXP P...