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!

Register Log in
  • 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 in DataStage from MS SQL server with a parameter

Status
Not open for further replies.
sqlskrathan

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
 
Status
Not open for further replies.

Similar threads

lgvalencia
  • Locked
  • Question
ACCESS VBA
Replies
0
Views
125
lgvalencia
lgvalencia
gmoorthy
  • Locked
  • Question
Autosys file watcher names
Replies
0
Views
126
gmoorthy
gmoorthy
yimitz
  • Locked
  • Question
InstRev function in SQL for HIR
Replies
0
Views
93
yimitz
yimitz
michaelvv
  • Locked
  • Question
datastage on AIX
Replies
0
Views
96
michaelvv
michaelvv
Iamundercover
  • Locked
  • Question
need solution for IIel load late arriving dimension
Replies
6
Views
151
Iamundercover
Iamundercover

Part and Inventory Search

Sponsor

Back
Top