I receive the an error after doing the following:
Table Definitions->Import->Stored Procedure Definitions->Ok->Import
I happen to know that I do not have execute privelages on the stored procedure. Is that required?DSR.MetaGeta(GET.PROC.COLUMNS)(SQLPrepare("{CALL "DQ_CD_INSERT" (NULL,NULL)}")): BCI Error:
SQLSTATE=S0002,CODE=-3824,[DataStage][SQL Client][ODBC][NCR][ODBC Teradata Driver][Teradata RDBMS] Macro 'DBTEST1.DQ_CD_INSERT' does not exist.
I also notice that when it calls the prep it is not qualifying the database name for the sp, and then complains that the object was not found in DBTEST1. The sp object is not located in DBTEST1, it is in another database DBTEST2.
When I selected the object to import, I selected the fully qualified name of DBTEST2.DQ_CD_INSERT.
Any suggestions? Your help is appreciated.
Thanks,
Greg