New to Datastage (stored procedure question)
Posted: Tue Jul 29, 2003 2:22 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 returned in step #2 into a output file.
How would I be able to do this (use the transformer stage and perhaps create a subroutine/function) to make the call to the stored procedure using one or more fields of the input file? Or is there any other way.
Any help would be appreciated.
Thanks.
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 returned in step #2 into a output file.
How would I be able to do this (use the transformer stage and perhaps create a subroutine/function) to make the call to the stored procedure using one or more fields of the input file? Or is there any other way.
Any help would be appreciated.
Thanks.