DSXchange

logic

Hi,
Usually there would not be any issues unless user created. The read me file would include almost everything of interest. And be sure to back up everything.
Hope this helps.

logic

Hi Ak77,
The stages that you are using create a separate process for themselves. So the problem would be with the memory buffer. You can adjust the buffer size. Exceeding the timeout will cause the mutex error.
hope this helps.

logic

Hi, My 1 cent Are you selecting the routine by clicking or typing it. Chances are that there might be a spelling error or a space overlooked. Although this might not be the case since all your jobs are not compiling and were running fine before. but just in case...... Also was the routine renamed/de...

logic

Hi Mahi,
Stored Procedure stage does support DB2 in Datastage 7.5.1 . With this release, the options are DB2 , Oracle , and Sybase. It does not support SQL server though.
Hope this helps.

logic

Would'nt making the jobs read only protect them frm deletion?

logic

Hi Bala,
Even if there are no links coming out of the last job in sequence,Check if there is an Exception handler stage included in the sequence as suggested by Ray..

logic

Hi Abhi,
I guess the error message is telling that there is a data type mismatch. Numeric for char or something similar.
Also the following post will help you.

viewtopic.php?t=93721&highlight=improper+data+type

logic

Hi Arn73, Ray,
I am sorry. Actually I did not read the whole post. I read the following part and actually wanted to point at it.

Code: Select all

You're doing what is called a pivot. You can checkout the Pivot stage

My Bad.

logic

Arn73,
The following post might help you to proceed.
viewtopic.php?t=96215&highlight=

logic

Hi ecwolf,
It would be more helpful to get the answers if you Post in the right Forum.
Thanks,

logic

Hi Deepak, I am sorry but I did'nt get it. :roll: Why would it be better to load to a CSV file. Because even if there are changes in Table A, they would be transferred to the hash File as suggested by Ray!!! Even if you are considering that when the business requirement changes then the changes have...

logic

If the rows are being rejected with a warning. modify settings of job to abort after 5 warnings. Use notification activity in sequence with exception handler.
Hope this helps

logic

I guess you will have to "flatten it" first

logic

Hi rekha,
Search the forum , you will find lot of stuff Also read the following post,

Code: Select all

http://www.dsxchange.com/viewtopic.php?t=95903&highlight=search+posting

A quick answer to your question would be performance

logic

If You directly use the

Code: Select all

search

feature then ,you might come across lots of material which will help you load into DB2 indirectly using a direct approach.
No offense meant, but really try searching for your answer please.

Search found 115 matches