Page 2 - Creating stored procedures with db2 Personal Edition on Windows XP

i have read this pdf and the link about the development client already and I have all that done what they said there

I don't have the development client explicitly installed. in the manual of the db2 personal edition there is nothing mentioned about that. and a friend of mine has the same version and it runs without explicitly installing the development client???
And I can compile and create ESQL C applications, which can only be created with the dev. app. client by this ibm text in the link...

I can't explain it to myself...maybe I should try it with another c/c++ compiler

Have your read the section Building SQL procedures on Windows servers in the following page:

http://www-106.ibm.com/developerwor...01alazzawe.html

Hello,

I Have found and removed the error. I am really happy.
That was a really bad error, that had nothing to do with the compiler or db2.
The Environment was correct. It had actually something to do with the execution of the compiler. In the log File was the text:
-------------------------------------------
"C:\>nmake /f C:\Programme\IBM\SQLLIB\function\routine\sqlproc.mak
cl -Ox -W2 -TC -D_X86_=1 -MD -I"C:\Programme\IBM\SQLLIB\include" P3490239.c /link -dll /out:P3490239.dll -def:P3490239.def "C:\Programme\IBM\SQLLIB\lib\db2api.lib"
P3490239.c
fatal error C1083: Cannot open source file: 'P3490239.c': No such file or directory"
-----------------------------------------------
and i saw that the compiler is called in the directory C:\
The Problem was that C:\ was not the directory where the C file to compile was. So there was the Error Message.
But now where was the mistake?
I had accidental looked at the comand processor in the Windows XP Registry. There is a Variable set in
HKEY_LOCAL_MACHINE -> Software -> Microsoft -> command Processor
which is named Autorun. There was the value cd\ set. That means everytime a ms do console gets open the Current path is set to C:\ and thats why the error occurs. Very tricky! Now it runs without Problems!

Thanks a lot for spending your time !

Great! I was just about to tell you to steal your friend's machine and be done with it.

>to steal your friend's machine

that was the next thing that I had in mind