All Forums Database
tdgi 31 posts Joined 02/08
19 Feb 2013
Can't compile UDF's on Windows

I can't seem to compile the UDFss run by DIP option 14 on Windows.
I've got Visual Studio 2005 and the Platform SDK installed.  It keeps failing on a missing limits.h.  This file is located in C:\Program Files\Microsoft Platform SDK\Include\crt.

Any idea why it's not finding the file?  Do I need to set some additional paths somewhere? The install guide mentions needing VS 2005, but not the Platform SDK.  I gathered that on my own and got it installed, but the compile process isn't using the headers provided by it...

Thanks!

tdgi 31 posts Joined 02/08
19 Feb 2013

Had a browser/network error earlier today while I was posting my question. So sorry for the extra threads and please forgive me for the noise! (The question still stands though) :)

tdgi 31 posts Joined 02/08
20 Feb 2013

I should have included more info.  Here's an excerpt from the resultant dip14.txt:
 
/************************************************************************
*  External Procedure SQLJ.INSTALL_JAR:                                 *
*    Description:  install user's jar file onto the server              *
*      To Invoke:  call SQLJ.INSTALL_JAR(locspec,jarname,deploy);       *
************************************************************************/

REPLACE PROCEDURE SQLJ.INSTALL_JAR
     (  IN locspec VARCHAR(1000),
        IN jarname VARCHAR(30),
        IN deploy  INTEGER )
LANGUAGE C
NO SQL
PARAMETER STYLE SQL
EXTERNAL NAME 'SL!xsplib';
REPLACE PROCEDURE SQLJ.INSTALL_JAR
     (  IN locspec VARCHAR(1000),
        IN jarname VARCHAR(30),
        IN deploy  INTEGER )
LANGUAGE C
NO SQL
PARAMETER STYLE SQL
EXTERNAL NAME 'SL!xsplib';

*** Procedure has been created.
*** Time was 1 second.
Errors/Warnings reported during compilation
--------------------------------------------------------------------------------
Microsoft (R) Program Maintenance Utility Version 8.00.50727.42
Copyright (C) Microsoft Corporation.  All rights reserved.

 cl /D_CRT_SECURE_NO_DEPRECATE /DWIN32  /GS- -D_USE_32BIT_TIME_T  /c /FoNCR
_new_delete.obj NCR_new_delete.cpp
Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 14.00.50727.42 for 8
0x86
Copyright (C) Microsoft Corporation.  All rights reserved.

NCR_new_delete.cpp
D:\Program Files\Teradata\Tdat\TDBMS\12.00.00.10\etc\sqltypes_td.h(53) : fa
tal error C1083: Cannot open include file: 'limits.h': No such file or dire
ctory
NMAKE : fatal error U1077: '"C:\Program Files\Microsoft Visual Studio 8\VC\
bin\cl.EXE"' : return code '0x2'
Stop.
 
Anyone know how to get it to use the limits.h and other headers located in C:\Program Files\Microsoft Platform SDK\Include\crt?
Many thanks!

tdgi 31 posts Joined 02/08
22 Feb 2013

Just in case anyone's wondering, I was able to fix this by reinstalling Visual Studio 2005.  I apparently outsmarted myself by attempting to keep the VS install small by not including "unnecessary" components.  Turns out I skipped too many.  Everything under the VC section needs to be installed. 

You must sign in to leave a comment.