I downloaded Gcc compiler and set the path and db2path...when i tested with one stored procedure, I got the result as

************************************************** *********

-- LOG FILE P6592513.log FOR PROCEDURE DB2ADMIN.TESTPROCEDURE

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P6592513.sqc

LINE MESSAGES FOR P6592513.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

-- DB2_SQLROUTINE_COMPILE_COMMAND=D:\cygwin\bin\db2gc c.bat SQLROUTINE_FILENAME

-- CONTENTS OF E:\PROGRA~1\IBM\SQLLIB\function\routine\sr_cpath.b at

-- CONTENTS OF E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P6592513.BAT

@echo on
set SQLROUTINE_FILENAME=P6592513
set db2path=E:\PROGRA~1\IBM\SQLLIB

-- COMPILATION COMMAND:

D:\cygwin\bin\db2gcc.bat P6592513

-- CONTENTS OF E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P6592513.def

LIBRARY P6592513
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8

-- COMPILATION MESSAGES FOR E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P6592513.c
-- C COMPILATION ERROR CODES: 0 0 1

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P6592513

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set db2path=E:\PROGRA~1\IBM\SQLLIB

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>D:\cygwin\bin\db2gcc.bat P6592513

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>setlocal

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>REM Set the DB2PATH variable to your DB2 base path, e.g., c:\ibm\sqllib

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>REM Set CYGWIN to your top-level CYGWIN directory.

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set DB2PATH=E:\Program Files\IBM\SQLLIB

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set CYGWIN=D:\cygwin

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>gcc -c -g -mno-cygwin -IE:\Program Files\IBM\SQLLIB\include -ID:\cygwin\usr\include P6592513.c -o P6592513.o

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>sed -e s/\_// P6592513.def 1>P6592513_m.def

E:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>dllwrap -mno-cygwin -target i386-mingw32 -o P6592513.dll P6592513.o E:\Program Files\IBM\SQLLIB\lib\db2api.lib --def P6592513_m.def
'gcc' is not recognized as an internal or external command,
operable program or batch file.
'dllwrap' is not recognized as an internal or external command,
operable program or batch file.

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

*******************************

Didn't know what is the problem..can anyone help?

-manga

Sorry if this is repetitive, but did you check out this article?
http://www7b.software.ibm.com/dmdd/l...306haungs.html

It seems like gcc is not in a PATH. Could you modify you global path (or local in db2gcc.bat) to include c:\cygwin\bin (or whatever is appropriate)

regards,
dmitri

I set my path to D:\cygwin\bin globally and db2 path to ..prog files\ibm\sqllib. also I included that in db2gcc.bat which is in d:\cygwin\examples....when i entered ,
db2 -td! -v -fsample.clp
I am getting this error.
I followed as it said in the URl mentioned by Marcus.
Looking forward for ur help in solving this!

-manga

Thanks for all ur help...

I played around with files and suddenly it worked.