Is there anyway to convert PL/SQL to DataStage?

[spkrimb]

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]

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]

Or call your pl/sql statement from a DS job

[spkrimb]

Or call your pl/sql statement from a DS job

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]

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]

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 DataStage.
2. Hire someone else to do that for you.
3. Some combination of the above (you do the analysis, they do the coding).

[spkrimb]

Thanks williams and ray.