DSXchange

You haven't configured DataStage for Teradata yet, which I assume would involve updating your "library path". Check the documentation for the connector for the steps involved.

You'd need to explain your job design at this point so we know exactly how it is set up. If you are still using a "combo" action, please specify which one you are using so we know the order it will try the actions.

ORA-01403: no data found

I would verify that your in-job zip code values do in fact match what is in the table. I really should rephrase that - figure out why they don't match since (at the moment) Oracle is telling you they don't.

I'll say it again - if your error is coming from the stage rather than the command line, leave the mail server property there empty if you aren't doing that already. See if that fixes things. If you can't get it to work from the command line then you've got bigger problems and need to involve your S...

Realize that for these combo actions to work, the first action must fail for the second to be triggered. An update fails if it doesn't find a row to update. An insert fails when it already exists and it is covered by a unique constraint of some kind so it physically cannot be inserted into the datab...

For UNIX and the Notification Activity stage, just leave the 'server' property empty.

Nope but I'd wager others with DB2 and DataStage experience do. What about whatever passes for a 'stored procedure' in DB2? A typical workaround would be to craft a procedure is owned by the table owner that performs the function in question and then your ETL functional user would be granted the abi...

Can't answer that question. Did you perhaps change the logging from one location to the other and what you are seeing are pre- or post-change? Or is it set differently per project? Perhaps it is specific to your version, something you haven't mentioned yet. You'd really need to put that in front of ...

Why post this again? You already have a perfectly lovely version of your question here and that is where you should back to if you have additional questions. This one is done.

<click>

The same way you would outside of DataStage. I would provide specifics if I could but I've never touched DB2 in my life. However, from hanging out here and reading the documentation (are you using the DB2 Connector?) it seems like DB2 always leaves a bulk loaded table with check constraints or refer...

Your DBA.

Exactly. It all depends on what resolution you are looking for.

hargun wrote:how can i resolve this one.

By ensuring that your value being looked up is in the lookup set and that your values are identical... including things like leading zeroes if you are dealing with a string.

OK, now your design is like.