DSXchange

Hi All,
Iam using Datastage 9.1 Version.

Iam supposed to use StoredProcedure Stage to call SQLServer Stored Procedure.

ReturnValue = Sp_CallSales(dateFrom, dateTo)

Here ReturnValue is 0/1
dateFrom, dateTo are input parameter to pass the dates

The procedure gives the data from specific table joins and get the data in the given range dates.


Thanks,
Vamsi

While loading the Parameters in StoredProcedure Stage -> Stage window

ParameterName MapToColumn Parameter Maker/literal ParameterType

ReturnValue MustSpecifyColumn ? Function
@dateFrom MustSpecifyColumn ? Input
@dateTo MustSpecifyColumn ? Input

Please let me know how can we pass the values here ?

Thanks,
Vamsi