Page 1 of 1
Store procedure in DataStage
Posted: Tue Feb 01, 2005 5:52 am
by peppinodicapri
I have tried to execute one procedure in stage ODBC: User-defined
SQL=call nameprocedure(); The procedure is executed several times
(loop). How I can avoid the loop?
Thanks
Posted: Tue Feb 01, 2005 6:50 am
by roy
Hi,
this sounds like your asking for answers so post in the correct forum (server or enterprise edition).
this 1 is for people ofering job opertunities not asking questions.
Posted: Tue Feb 01, 2005 6:54 am
by ArndW
It will also help to post into the correct forum, this one is used by prospective employers looking for DS expertise. I am sure it will be moved to the appropriate section when the Admins in the USA and elsewhere login.
To address your question - A stage as a main source in DataStage is not like a statement in a programming language; it is meant to be executed repeatedly for a whole dataset or SELECT from a database. Thus you can ensure that it only executes once by making the dataset 1 row. Perhaps you could explain what you intend to do and post that into the server forum and someone will certainly respond.