When I compiled my stored procedure I am getting following error
5863: Problem encountered during compilation phase of C code.
I have installed visual studio 2008 in my box with all the options. Here is the result of cufconfig -0. Let me know what I am missing in my box. I have teradata 12.00 in my box in WS2003. Thanks in advance.
I am able to solve this problem by setting environment variables with missing path. It is is very difficult to find which path is missing in the environment variable. You need to directly execute cl.exe and find out all missing path.
Write your procedure in some file and run below script in debug mode
Diagnostic SPLDEBUG on for session;
Check .merr file under Tdat\TdTemp\TDSPTemp for error.
- Could you tell me which path Teradata enviroment variables do you have? - Which *.EXE should I run? CL.EXE or PCL.EXE? - Could write a sheet of a script example using "Diagnostic SPLDEBUG on for session; .compile file"?
One more time, Thank you so much for the attention!