hi everyone,
i need to convert the pl/sql code into datastage code.can anyone explain me the process of conversion.i searched in dsxchange forums. i didnt find it and searched in the google too.it would be a great help if anyone explain the process.
thanks
Is there anyway to convert PL/SQL to DataStage?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
pl/sql to datastage
Hi Arun ,arunkumarmm wrote:Or call your pl/sql statement from a DS job
Is there anyway can u tell me how to call pl/sql statement from DS job as i am new to datastage.
Thanks
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: pl/sql to datastage
While you can run PL/SQL through the Stored Procedure Stage it is not likely this is what you are being asked to do. There is no benefit and one more layer of complexity and another point of failure added to the process. Craig's suggestion is correct, read the stored procedure. Understand what the procedure produces as an end result and create the same result with DataStage.
I'm hoping that your employer also provided some level of training before giving you this assignment. It wasn't the case for me when I started, but it really gives a solid foundation to be able to start out.
I'm hoping that your employer also provided some level of training before giving you this assignment. It wasn't the case for me when I started, but it really gives a solid foundation to be able to start out.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Is there anyway to convert PL/SQL to DataStage?
1. Analyze the logic in the PL/SQL and reproduce that logic in DataStage.spkrimb wrote:i need to convert the pl/sql code into datastage code.can anyone explain me the process of conversion.
2. Hire someone else to do that for you.
3. Some combination of the above (you do the analysis, they do the coding).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
conversion
Thanks williams and ray.