Hi All

I am new to db2....can anyone in the list please tell me how to
run sql procedures on db28.1 on win2k.

When I try to build the procedure it is throwing me a error "nmake
Fatal Error....".I have registered all the variables according to
the document.

After all the variables are set I am getting the Following
error.

DB2ADMIN.Procedure6 - Build started.
Create stored procedure returns -7032.

-- LOG FILE P4073920.log FOR PROCEDURE DB2ADMIN.PROCEDURE6

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp\P4073920.sqc


LINE MESSAGES FOR P4073920.sqc

------
--------------------------------------------------------------------

SQL0060W The "C" precompiler is in progress.

SQL0091W Precompilation or binding was ended with "0"

errors and "0" warnings.


--
DB2_SQLROUTINE_COMPILER_PATH=c:\Progra~1\micro~1\VC98\Bin\vcvars32.bat

-- DB2_SQLROUTINE_COMPILE_COMMAND=cl -Od -W2 /TC -D_X86_=1
-I\include SQLROUTINE_FILENAME.c /link -dll
-def:SQLROUTINE_FILENAME.def /out:SQLROUTINE_FILENAME.dll \lib
\db2api.lib

-- FAILED TO OPEN c:\Progra~1\micro~1\VC98\Bin\vcvars32.bat


-- CONTENTS OF
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp\P4073920.BAT

@echo on
set SQLROUTINE_FILENAME=P4073920
set db2path=C:\PROGRA~1\IBM\SQLLIB

-- COMPILATION COMMAND:

cl -Od -W2 /TC -D_X86_=1 -I\include P4073920.c /link -dll
-def:P4073920.def /out:P4073920.dll \lib \db2api.lib


-- CONTENTS OF
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp\P4073920.def

LIBRARY P4073920
EXPORTS [Email Address Removed] COMPILATION MESSAGES FOR
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp\P4073920.c
-- C COMPILATION ERROR CODES: 0 0 128


C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp>set
SQLROUTINE_FILENAME=P4073920



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp>set
db2path=C:\PROGRA~1\IBM\SQLLIB



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp>cl
-Od -W2 /TC -D_X86_=1 -I\include P4073920.c /link -dll
-def:P4073920.def /out:P4073920.dll \lib \db2api.lib


-- END OF LOG FILE (SQLCODE: -7032)

DB2ADMIN.Procedure6 - Build failed.
DB2ADMIN.Procedure6 - Roll back completed successfully.


Please do the needfull with all your Tips and suggestions

Regards

Ram


DB2 & UDB email list listserv db2-l LazyDBA home page