Been playing with Teradata express on my desktop and I have been trying to create a, external user defined stored proc in C and attaching it to an internal Stored Proc. For some reason it is not liking the syntax on the external name. I have tried every which way I could and even placed the source C code in the directory where the Database files exist but it still complains with following error:-
Replace Procedure Failed  Source code for UDF or External Stored Procedure must reside on the Teradata Server.
Here is the statement that creates the stored proc:-
I have tried the following too with no success:-
EXTERNAL NAME 'CS!sqlxspex!c:\Program Files\Teradata\sqlExp.c';
Would really appreciate it if someone out there can find the problem with the syntax and possibly offer a solution.