Hi,
I am using DS 7.5,I need info on Stored procedure stage.Is it possible to call a function in Stored procedure stage.Bcoz i am returrning some value and i need to capture that...
Will u Heilp me on this.
Thanks,
Siva.G
Is it possible to call a oracle function in Stored Procedure
Moderators: chulett, rschirm, roy
Siva,
what does page 9 of the "Stored Procedure Stage Guide 2.0" say on this subject?
what does page 9 of the "Stored Procedure Stage Guide 2.0" say on this subject?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Is it possible to call a oracle function in Stored Proce
Hi,
I am not having that document ,Will some one help me on this,Otherwise give link where i can find this document.
Thanks,
Siva.G
I am not having that document ,Will some one help me on this,Otherwise give link where i can find this document.
Thanks,
Siva.G
Documentation for Stored Procedure Stage
Siva,
Assuming you have a standard install of DataStage, all of the documentation is online on your client. Look in the "Ascential DataStage" folder on the Start Menu for "Online Documentation". Click on "DataStage Documentation" to bring up the main index of all documents.
Next go to "Plug-in Documentation" since the database access methods are all considered plug-ins. On the second page (scroll down or hit the "Continued" button. You'll see the link for the "DataStage Stored Procedure Guide".
If you don't have any of the documentation installed on your PC I'd recommend getting an install CD to load them, or copying them from someone who does have the documentation, because you'll need them (a lot!).
Assuming you have a standard install of DataStage, all of the documentation is online on your client. Look in the "Ascential DataStage" folder on the Start Menu for "Online Documentation". Click on "DataStage Documentation" to bring up the main index of all documents.
Next go to "Plug-in Documentation" since the database access methods are all considered plug-ins. On the second page (scroll down or hit the "Continued" button. You'll see the link for the "DataStage Stored Procedure Guide".
If you don't have any of the documentation installed on your PC I'd recommend getting an install CD to load them, or copying them from someone who does have the documentation, because you'll need them (a lot!).
-
- Participant
- Posts: 41
- Joined: Wed Mar 05, 2003 1:28 am
Pal,
I have 7.5.1 installed at work and I went into the directory and checked the version before posting. Perhaps there was a change between the initial 7.5 and the newest release.
I have 7.5.1 installed at work and I went into the directory and checked the version before posting. Perhaps there was a change between the initial 7.5 and the newest release.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I'll send it to you
You can either post your email here, or send an email to andy@dsxchange.com and I'll reply with the 2.0 document. Because it is a copyrighted document IBM does frown on us posting it (only they are allowed to post official IBM documents), but they won't have a problem with us sending you a copy via email.
-
- Participant
- Posts: 41
- Joined: Wed Mar 05, 2003 1:28 am