New to datastage (Calling stored procedures)
Posted: 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
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