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
Store procedure in DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Thu Jan 27, 2005 8:34 am
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.
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.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>