Thanks Ioffe, Where and how can I set these env? (AIX and WInNT). I'm using DB2 Development centre to create these stored procedures. Please help
regards -----Original Message----- From: Ioffe, Dimitry [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 3:13 PM To: 'Sunil Inchal'; [EMAIL PROTECTED] org Subject: RE: [DB2EUG] Can't create DB2 Stored Procedure Sunil, your call to nmake is failing. If you really do mean nmake, not make, than make sure that you set your c/c++ profile correctly. Your compiler env. is set up via either DB2_SQLROUTINE_COMPILER_PATH or $INSTHOME/sqllib/function/routine/sr_cpath file. Basically once you sourced it you should be able to run all c/make commands by hand. Since output looks like WinNT one you probably will have to set up env. a bit diff. in terms of exporting it other than that rest should be the same. Regards, -----Original Message----- From: Sunil Inchal [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 3:42 PM To: [EMAIL PROTECTED] org Subject: [DB2EUG] Can't create DB2 Stored Procedure Hi all, I'm creating a test stored procedure (simple one)in DB2 and am getting the following error messages. I tried thro' CLP and Development centre, both on WiNT and AIX boxes. I just couldn't create a simple Stored Procedure. Please help me to know how to deploy stored procedures to the database. By the way this is SQL stored procedure. ADMINISTRATOR.PROCEDURE1 - Build started. Create stored procedure returns -7032. -- LOG FILE P4174751.log FOR PROCEDURE ADMINISTRATOR.PROCEDURE1 -- DB2_SQLROUTINE_PREPOPTS= -- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P41 74751.sqc LINE MESSAGES FOR 4174751.sqc ------ -------------------------------------------------------- ------------ SQL0060W The "C" precompiler is in progress. SQL0091W Precompilation or binding was ended with "0" errors and "0" warnings. -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sr_cpath.bat -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P41 74751.BAT @echo on set SQLROUTINE_FILENAME=P4174751 set db2path=C:\PROGRA~1\IBM\SQLLIB -- COMPILATION COMMAND: nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.mak -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P41 74751.def LIBRARY P4174751 EXPORTS [EMAIL PROTECTED] [EMAIL PROTECTED] -- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P41 74751.c -- C COMPILATION ERROR CODES: 0 0 1 C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>set SQLROUTINE_FILENAME=P4174751 C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>nma ke /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.mak 'nmake' is not recognized as an internal or external command, operable program or batch file. -- END OF LOG FILE (SQLCODE: -7032) ADMINISTRATOR.PROCEDURE1 - Build failed. ADMINISTRATOR.PROCEDURE1 - Roll back completed successfully. - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
