DSXchange

Hello Forum,

I receive the an error after doing the following:

Table Definitions->Import->Stored Procedure Definitions->Ok->Import

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 happen to know that I do not have execute privelages on the stored procedure. Is that required?

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

After consulting the vendor on this, they mentioned that they have not tested Stored Procedures in Teradata, and do not support it.

They did mention that you might be able to get it to work, but you're on your own.

Greg

They are supported (in parallel jobs at least) in version 8.0. Given that server jobs can also use the new connectors, I would assume that they are supported in server jobs too.