New to datastage (Calling stored procedures)

datastageuser · Post by **datastageuser** » Mon Jul 28, 2003 3:17 pm

Hi!,

I am new to datastage (just going through the tutorial and the datastage developer's help). I have been able to write some simple transfromation jobs and run them.

What I want to achive:
1)Get each record from an input file
2)Call an Oracle stored procedure which would take some fields from the record, do some processing and returns another record.
3) Save this record into a output file.

How would I be able to use the transformer stage (perhaps create a subroutine/function) to make the call to the stored procedure using one or more fields of the input file?

Any help would be appreciated.

Thanks.

E-mail This Thread To A Friend

kcbland · Post by **kcbland** » Mon Jul 28, 2003 4:12 pm

From a purely academic exercise you would use an Oracle OCI lookup using a stored procedure SQL action. Your manual shows you how to do this and remain within the graphical metaphor without writing a subroutine/function (very poor design choice).

roy · Post by **roy** » Wed Aug 06, 2003 6:14 am

Hi,
If possible I would rather use DS for The Data Transformation which is the whole idea of using DS, unless the SPL has very complex logic which will take to long to implement in DS.
Good Luck,
Roy.