Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

load Stored procedure with a parameter into DataStage

Status
Not open for further replies.

sqlskrathan

Programmer
Sep 30, 2003
4
US
Hi,
I trying to load Stored prcedure which accepts one argument into DATASTAGE. While I was importing It asked for the argument value and when I given a value to it , It loaded the stored procedure into the DATASTAGE but no data to view. Please if anybody know how to load the Stored procedure with an argument into DataStage .


By the way I am using MS SQL Server 2000 and DataStage7

Shashi
 
What is DataStage?

Why are you trying to 'load' a stored procedure into it?

Depending on what DataStage is, I would create the stored procedure in SQL Server and run it from DataStage. For example, I create a stored procedure in SQL Server (usp_testproc) with one variable (@testvariable). In Crystal Reports I can run EXEC usp_testproc 'variableinput'.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top