How can we call parameters in StoredProcedure in ParallelJob

[krishna410]

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

[krishna410]

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