I have a problem with stored procedures on data warehouse center.
When i build my stored procedures on Stored Procedures Builder, i would invoke her on the data warehouse center to develop ETL processes.
I define this procedures like UDP's and i define the table SYSIBM.SYSPROCEDURES like a target table of this UDP. I i try to run the UDP on my process, i receive an error that says the agent site can't invoke the command "runUDP".
Where the stored procedures are stored?..in my OLTP Database or im my Control Warehouse Database?..How can i resolve my problem?