Please help me out. I am trying to build a simple DB2 SQl Procedure created thru DB2 Devlopment Center Wizard. I have spend two working days and tried all the suggestions mentiond on this forum for building SQL Proc, but no success.
My Error reads as:
"Command line error D2003 : missing source filename"
For your refernce I am giving you the complete steps that I follwed for creating the SQL Proc and the error message generated on Building it :
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.