Is there anyway to convert PL/SQL to DataStage?

spkrimb · Participant Joined: 23 Jul 2010 Posts: 8 Points: 53

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

chulett · Posted: Fri Jul 23, 2010 4:57 pm

There's not much to explain other than you document / break down what the PL/SQL code is doing and then you 'code' the equivalent processing in a DataStage job.

arunkumarmm · Posted: Wed Jul 28, 2010 12:07 pm

Or call your pl/sql statement from a DS job Wink

spkrimb · Participant Joined: 23 Jul 2010 Posts: 8 Points: 53

arunkumarmm wrote:

Or call your pl/sql statement from a DS job Wink

Hi Arun ,

Is there anyway can u tell me how to call pl/sql statement from DS job as i am new to datastage.

Thanks

kwwilliams · Participant Joined: 21 Oct 2005 Posts: 245 Points: 1863

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.

ray.wurlod · Posted: Thu Jul 29, 2010 3:15 pm

spkrimb wrote: i need to convert the pl/sql code into datastage code.can anyone explain me the process of conversion. 1. Analyze the logic in the PL/SQL and reproduce that logic in DataStag ...

What's this?

spkrimb · Participant Joined: 23 Jul 2010 Posts: 8 Points: 53

Thanks williams and ray.