Store procedure in DataStage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
peppinodicapri
Participant
Posts: 5
Joined: Thu Jan 27, 2005 8:34 am

Store procedure in DataStage

Post 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
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post 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.
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
Image
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post 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.
Post Reply