STORED PROCEDURE SETUP???

[Mike]

ok getting a little miffed here. What in specific do I need to be able
to compile and run stored procedures in version 8.1/WIN2k? I have a
developer using Stored procedure builder who when he has created a
stored procedure and compiles it gets a -7032n with it saying it can
not find the command nmake. So I looked through some links and am as
confused as ever. Here is some of the information I have gathered but
none of it together all makes sense:

1. I must installed the app dev client on the server ????
2. I must install a compiler??? Where? on the server or on the
developers workstation?
b. If so, where am I supposed to get this compiler and of what type?
Yes I have VA for C++ but why should I have to load that whole product
to get a compiler for stored procedures to work on db2?
3. There are mention of variables that need to be set. On the server
or on the developers workstation?

I must be missing something real easy here because I am not used to
IBM putting out something this muddled. Why in the world would these
items not be part of the db install or the dev client? Why would you
have to load a dev client on a DB SERVER??? If this is the case, (and
I am a die hard DB2 fan) Sql server has db2 beat in this area hands
down as far as simplicity goes. This almost seems to be more trouble
than it is worth. Was hoping to do some simple stored procedure tests
to see if a particular program would have a performance impact using a
SP. Please help clear this up for me. Thanks in advance!!

[Mark A]

"Mike" <mi*********@thomson.net> wrote in message
news:a3**************************@posting.google.c om...

ok getting a little miffed here. What in specific do I need to be able
to compile and run stored procedures in version 8.1/WIN2k? I have a
developer using Stored procedure builder who when he has created a
stored procedure and compiles it gets a -7032n with it saying it can
not find the command nmake. So I looked through some links and am as
confused as ever. Here is some of the information I have gathered but
none of it together all makes sense:

1. I must installed the app dev client on the server ????
2. I must install a compiler??? Where? on the server or on the
developers workstation?
b. If so, where am I supposed to get this compiler and of what type?
Yes I have VA for C++ but why should I have to load that whole product
to get a compiler for stored procedures to work on db2?
3. There are mention of variables that need to be set. On the server
or on the developers workstation?

I must be missing something real easy here because I am not used to
IBM putting out something this muddled. Why in the world would these
items not be part of the db install or the dev client? Why would you
have to load a dev client on a DB SERVER??? If this is the case, (and
I am a die hard DB2 fan) Sql server has db2 beat in this area hands
down as far as simplicity goes. This almost seems to be more trouble
than it is worth. Was hoping to do some simple stored procedure tests
to see if a particular program would have a performance impact using a
SP. Please help clear this up for me. Thanks in advance!!

You need a C or C++ compiler on the server for stored procedures. This
restriction will be lifted in the DB2 release code named "Stinger" which is
expected to be version 8.2 (or maybe 9.1). I believe it will ship early next
year.

[Larry Menard]

Just to follow up on Mark's response...

1) "Stinger" will likely be out before next year.
2) See the samples in \sqllib\samples\sqlproc.

--
Larry Menard
IBM Workstation Database (DB2) Information Development, Samples Coordinator
Defender of Geese and of All Things Natural
"Mark A" <no****@nowhere.com> wrote in message
news:fX****************@news.uswest.net...

"Mike" <mi*********@thomson.net> wrote in message
news:a3**************************@posting.google.c om...

ok getting a little miffed here. What in specific do I need to be able
to compile and run stored procedures in version 8.1/WIN2k? I have a
developer using Stored procedure builder who when he has created a
stored procedure and compiles it gets a -7032n with it saying it can
not find the command nmake. So I looked through some links and am as
confused as ever. Here is some of the information I have gathered but
none of it together all makes sense:

1. I must installed the app dev client on the server ????
2. I must install a compiler??? Where? on the server or on the
developers workstation?
b. If so, where am I supposed to get this compiler and of what type?
Yes I have VA for C++ but why should I have to load that whole product
to get a compiler for stored procedures to work on db2?
3. There are mention of variables that need to be set. On the server
or on the developers workstation?

I must be missing something real easy here because I am not used to
IBM putting out something this muddled. Why in the world would these
items not be part of the db install or the dev client? Why would you
have to load a dev client on a DB SERVER??? If this is the case, (and
I am a die hard DB2 fan) Sql server has db2 beat in this area hands
down as far as simplicity goes. This almost seems to be more trouble
than it is worth. Was hoping to do some simple stored procedure tests
to see if a particular program would have a performance impact using a
SP. Please help clear this up for me. Thanks in advance!!
You need a C or C++ compiler on the server for stored procedures. This
restriction will be lifted in the DB2 release code named "Stinger" which

is expected to be version 8.2 (or maybe 9.1). I believe it will ship early next year.

[Mike]

So is the answer to 1 yes? Do I need to install the dev client and a
compiler both on the server for sp's to work? If so please recommend a
compiler that is being used out there that is free and does not
require licensing.
Thanks,
Mike

"Larry Menard" <lm*****@GoSpamYourself.com> wrote in message news:<cc**********@hanover.torolab.ibm.com>...

Just to follow up on Mark's response...

1) "Stinger" will likely be out before next year.
2) See the samples in \sqllib\samples\sqlproc.

--
Larry Menard
IBM Workstation Database (DB2) Information Development, Samples Coordinator
Defender of Geese and of All Things Natural
"Mark A" <no****@nowhere.com> wrote in message
news:fX****************@news.uswest.net...

"Mike" <mi*********@thomson.net> wrote in message
news:a3**************************@posting.google.c om...

ok getting a little miffed here. What in specific do I need to be able
to compile and run stored procedures in version 8.1/WIN2k? I have a
developer using Stored procedure builder who when he has created a
stored procedure and compiles it gets a -7032n with it saying it can
not find the command nmake. So I looked through some links and am as
confused as ever. Here is some of the information I have gathered but
none of it together all makes sense:

1. I must installed the app dev client on the server ????
2. I must install a compiler??? Where? on the server or on the
developers workstation?
b. If so, where am I supposed to get this compiler and of what type?
Yes I have VA for C++ but why should I have to load that whole product
to get a compiler for stored procedures to work on db2?
3. There are mention of variables that need to be set. On the server
or on the developers workstation?

I must be missing something real easy here because I am not used to
IBM putting out something this muddled. Why in the world would these
items not be part of the db install or the dev client? Why would you
have to load a dev client on a DB SERVER??? If this is the case, (and
I am a die hard DB2 fan) Sql server has db2 beat in this area hands
down as far as simplicity goes. This almost seems to be more trouble
than it is worth. Was hoping to do some simple stored procedure tests
to see if a particular program would have a performance impact using a
SP. Please help clear this up for me. Thanks in advance!!

You need a C or C++ compiler on the server for stored procedures. This
restriction will be lifted in the DB2 release code named "Stinger" which

is

expected to be version 8.2 (or maybe 9.1). I believe it will ship early

next

year.

[Knut Stolze]

Mike wrote:

So is the answer to 1 yes? Do I need to install the dev client and a
compiler both on the server for sp's to work?

No, you don't have to. You need the compiler on your development box. The
compiled procedures can then be moved to the production system (where no
compiler is needed) using the GET ROUTINE and PUT ROUTINE commands.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Mike]

Thanks for the info guys. I finally did find detailed instructions on
how to set this up and using a free compiler. Followed the
instructions in the link below to the tee and everything is working
properly now.

http://database.ittoolbox.com/browse...6haungs%2Ehtml