InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 17:20:53 GMT20http://www.teradata.com/teradataforum/Topic16059-9-1.aspxYes you need to execute CL.EXE. You will get exact command in .merr file.Enviromnet variable can be set using Control Pannel -> System - > Advance tab -> Environment variableadd missing path in PATH variable. Don't forget to include visual studio IDE path.You might need to create LIB variable and set library path.Wed, 08 Jul 2009 14:27:54 GMTvptdatahttp://www.teradata.com/teradataforum/Topic16059-9-1.aspxThank you so much for the answer!Could solve my some doubts I got?- 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!Kind Regards,AndersonWed, 08 Jul 2009 14:04:05 GMTaolympiohttp://www.teradata.com/teradataforum/Topic16059-9-1.aspxI 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 modeDiagnostic SPLDEBUG on for session;.compile file Check .merr file under Tdat\TdTemp\TDSPTemp for error.Wed, 08 Jul 2009 13:29:31 GMTvptdatahttp://www.teradata.com/teradataforum/Topic16059-9-1.aspxI've got the same problem when I was creating a stored procedure in Teradata SQL Assistant.What can I do to solve this problem?Thanks,AndersonWed, 08 Jul 2009 13:18:04 GMTaolympiohttp://www.teradata.com/teradataforum/Topic16059-9-1.aspxHi, 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.Version: 5ModTime: 1246900985SWDistNodeID: 33SourceDirectoryPath: D:\Program Files\NCR\Tdat\tdconfig\Teradata\tdbs_udf\usr\CompilerTempDirectory: D:\Program Files\NCR\Tdat\TdTemp\UDFTemp\UDFLibraryPath: D:\Program Files\NCR\Tdat\tdconfig\udflib\CompilerPath: d:\Program Files\Microsoft Visual Studio 9.0\VC\bin\CL.EXELinkerPath: d:\Program Files\Microsoft Visual Studio 9.0\VC\bin\LINK.EXEUDFServerMemPath: D:\Program Files\NCR\Tdat\TdTemp\udfsrv\MaximumCompilations: 10UDFServerTasks: 2SecureServerAMPs: 20ParallelUserServerAMPs: 2SecureServerPEs: 20ParallelUserServerPEs: 2TDSPLibBase: D:\Program Files\NCR\Tdat\tdconfig\tdsplib\SecureGroupMembership: tdatudfUDFLibPath:UDFIncPath:UDFEnvFile:CLILibPath: D:\Program Files\NCR\Teradata Client\cliv2\libCLIIncPath: D:\Program Files\NCR\Teradata Client\cliv2\incCLIEnvFile:Mon, 06 Jul 2009 17:26:12 GMTvptdata