Can't compile UDF's on Windows

Database
Enthusiast

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!

3 REPLIES
Enthusiast

Re: Can't compile UDF's on Windows

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) :)
Enthusiast

Re: Can't compile UDF's on Windows

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!

Enthusiast

Re: Can't compile UDF's on Windows

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.