I am trying to build a DB2 SQl Procedure using DB2 Development centre.On building the error occurs as :
Command line error D2003 : missing source filename.
For your reference I am giving you the steps I follwed :
Database used : DB2 UDB v8.1(Evaluation copy).
1. Insatalled VC++ 6.0
2. Set Environment Variable (SYSTEM) DB2_SQLROUTINE_COMPILER_PATH=C:\Program Files\Microsoft Visual Studio\VC98\bin\vcvars32.bat
3. Invoked DB2 Development Centre to create the SQl Store procedure. For your refernce I am also mentioning the steps taken thru :
„« From the Develpoment Centre Launch Pad, created new project,added connection (Connection Type ˇVONLINE)
„« Provided the user/pwd as db2admin/db2admin and then followed the steps directed by wizard to create the SQL procedure.
4. In the output window I got Database connection as Success but the Build Status as : ˇ§ERRORˇ¨
5. Below is the Build error:
DB2ADMIN.PROCEDURE1 - Build started.
Create stored procedure returns -7032.
-- LOG FILE P1542576.log FOR PROCEDURE DB2ADMIN.PROCEDURE1
-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\TE ST_KON\DB2ADMIN\tmp\P1542576.sqc
-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\TE ST_KON\DB2ADMIN\tmp\P1542576.c
-- C COMPILATION ERROR CODES: 0 0 2
Setting environment for using Microsoft Visual C++ tools.