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
How can we call parameters in StoredProcedure in ParallelJob
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Wed Mar 05, 2008 3:47 am
- Location: Mumbai
-
- Participant
- Posts: 10
- Joined: Wed Mar 05, 2008 3:47 am
- Location: Mumbai
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
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