DSXchange

Hi Naveen, I just figured out myself and came here to saw the same logic you mentioned here. Anyways thanks a bunch pal. Both constraints IN1.NOTFOUND and ISNULL(IN1.reg_number) are working. But both of them are not working directly on ODBC2. I had to change the ODBC2 to HASHED_ODBC2. Just curious i...

Here is my scenario. ODBC1 --> recordset having 2 columns (reg_id, reg_number) ODBC2 --> recordset having 1 column (reg_number) I want to delete all the records in ODBC1 whose reg_number is not found in ODBC2. ODBC1 and ODBC2 are both Sql Server but different databases. I wrote a delete Stored proce...

Ok.... I dont understand what you are talking about.... Let me give you more clarity on what I am talking about. I am using DataStage Designer Version 7.5 I created a New "Job Sequence" which runs 11 Jobs in some orderly fashion. I have to trap each of those 11 jobs Success/Failure, all fa...

Arrangement of arrows joining two blocks is not proper in sequencer.
I have no control over the direction of the arrow marks, even i change the description poistion and save it, it goes back to original position, and its all crumbled. Is there any way to make it look good?