I have a job that is similar in flow to:
Code: Select all
OCI --> StoredProc --> OCI
1. The stored procedure has input args and returns output args
2. The stored procedure takes values from Oracle OCI, but lives in SQL Server
3. SQL Server stored procedures aren't supported in the standard DataStage StoredProc stage, so ODBC is the way
I'm thinking I could call the custom routine in a transformer thus making it flow like:
Code: Select all
OCI --> Transformer --> OCI