DSXchange

You will get this error when you have the same column names in the input, reference and output links. As maveric said try to rename the outputs coming from reference link differently or if you don't need any data coming from the reference links try to delete the columns that are not key columns. Exa...

We have a "Program.exe" which we are running manually and has two files as inputs i.e., MS-DOS>Program.exe input1.txt, input2.txt and we had installed .NET 2.0 to run this batch file since it is written in C sharp. This is all done on local windows computer where we have .NET installed. Bu...

I too would like to know how you are running .exe program through command prompt, since we are facing the same problem.

Thanks in advance

How exactly are you running the dsjob command and passing the parameters? Whatever values need to be determined during run time can be parametrized and its value can be passed during run time. Another question, how are you running dsjob.exe, used for windows, on a unix box??? I too would like to kn...

Hi,

Just wanted to know whether we can run DTS or SSIS packages sitting on MS SQL server 2005 through DataStage. Any kind of information on this is greatly appreciated.

Thanks in advance.

Hi, The column in question has data as 1000, Z123 etc., Thanks. What is the data-type and length for this field in source? How are you cinfirming that the ' last digit' is missing through 'view data' or by query on target table. When you load is working fine with server job, it will work with paral...

Hi, I have a simple job of copying data one table in one Database to another table in other database. But when I trying to copy the data using Parallel Extender job it is truncating the last digit in the column even though the Column is defined as varchar. I had tried increasing the length of the co...

Even the before/after sql tab in the DRS stage. Hi Dsgurus, You had mentioned we can run the stored procedures in Before/After SQL tab in DRS stage, I had tried this but i am getting an error message. And the SQL i had used is 'EXECUTE sp_name'. So could you please let me know exact SQL for calling...

Hi,

Just wanted to know is there any way we can run the stored procedures sitting on MS SQL server 2000 on Datastage. Any suggestions are most welcome.

Thanks in advance.

Hi, I am experience some problem while designing a Sequence job in Parallel job. What's happening while designing a Sequencer the designer window is automatically closing with out giving me an appurtunity to even save the Sequence Job that I had designed. Can you explain to me why it is happening li...

Hi, I am sort of new in using the Parallel Extender, but Iam surprised to see that we can create routines in Parallel Extender. So my question would be is there any documentation available in helping me out in creating the routines in PX?. I had tried creating them through Datastage Manager but no l...

Are the patches for DataStage Client installed properly on your computer ?. If not try to install them first that will solve your problem.

Hi, I am getting this error while trying to access my job. ERROR: Cannot find any process numbers for stages in job XXX_Jobname_XXXXXX I had tried to CleanUp using CleanUp Resources, but it not releasing the locks, so then i had tried DS.TOOLS with option 7. But is not allowing me to clean up saying...

Hi, I am getting this error while trying to access my job. ERROR: Cannot find any process numbers for stages in job XXX_Jobname_XXXXXX I had tried to CleanUp using CleanUp Resources, but it not releasing the locks, so then i had tried DS.TOOLS with option 7. But is not allowing me to clean up saying...

But someone else on the early part of the learning curve might like to benefit from your experience. Can you advise what stage type you used and what expression(s) you used to solve this? Hi Ray, Let me explain it clearly. Iam getting date format from flat file which is in the form of CYYMMDD ., in...