DSXchange

I am reading from an oracle table and writing to a file but I have to have header and trailer for each ship from location.The Header has a certain format and so does trailer too ,which contains the ship from location info and trailer contains the record count. My problem is that though i can get the...

Thanks for the Reply. What I am looking for. --------------------------------------------------------------- I am reading data from a file, For each row of the file need to pass one of the columns to a Oracle Stored Procedure, the Procedure contains either select/insert/Update/Delete statement and p...

I need to call a Oracle Stored Procedure that accepts input from Datastage and returns values back to the Datastage job. I have come accross lot of stuff about this in this forum and nowere it's mentioned clearly how it works. Can someone please give me a clear picture of this, means what stage I ne...