DSXchange

chulett wrote:What kind of issues, exactly?

There is no such issues but I want to use it as parameters so that I can pass them in my higher environments.

I am using Store Procedure stage to run of my oracle store procedure in Datastage 8.7.

I am facing issue while parameterizing the connection details(DSN,USER NAME, PASSWORD) in Genral tab of Store Procedure stage. How I can run it in upper environments. (QA,PROD).

I have a SQL Server store proc which is taking 1 input and generating 1 output. I want to use it in Datastage 8.7. 1. I am unable to run it using ODBC stage. Trying with command: Exec CustomBuyingRepository.po.uspCreateUniversalItemNum 1 2. Trying through Store_Proc Stage. Warning: Stored_Procedure_...

Hi, How to use Message handler in Sequence?

I am trying to go to Tools--> Message Handler and adding the message ID of my Warning and the example text. But still it is showing the warnings.

How to fail job if there is no match on the key using Join stage?

Note: Due to high volume of data I can't use Lookup stage.