Posted: Mon Jul 21, 2003 4:56 am
You could try user-defined SQL using CALL - I do not know whether this will work.
As a general rule, definitions of stored procedures to be invoked by DataStage have to be imported (or created) first (so that the number of arguments can be verified) and must have at least a return result set. In my experience, at least one input parameter is required, even if the stored procedure ignores it. I have only ever invoked stored procedures through an ODBC stage. DataStage Designer's Help suggests that stored procedures can only be used from ODBC or BCP stages.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
As a general rule, definitions of stored procedures to be invoked by DataStage have to be imported (or created) first (so that the number of arguments can be verified) and must have at least a return result set. In my experience, at least one input parameter is required, even if the stored procedure ignores it. I have only ever invoked stored procedures through an ODBC stage. DataStage Designer's Help suggests that stored procedures can only be used from ODBC or BCP stages.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518