Compiling stored procedures

[Gregor Kovaè]

Hi!

We are using DB2 8.1 with FixPack 3 on Windows 2000 Server.

We want to use stored procedures with our database, but when creating a
simple stored procedure in a file and running that file through Command
Line Processor we get an error about not being able to find nmake.

Does this mean we also have to have a C compiler ? Is there any
documentation how to set the environment for creating stored procedures up?

Thanks for any help.

Best regards,
Kovi

[Larry Edelstein]

If you are using SQL Stored Procs, you need a C Compiler on at least one
machine with each os level/db2level. You can move the executables to other
machines with the same os level/db2level. See the Application Building Guide.

Larry Edelstein

Gregor Kovaè wrote:

> Hi!
>
> We are using DB2 8.1 with FixPack 3 on Windows 2000 Server.
>
> We want to use stored procedures with our database, but when creating a
> simple stored procedure in a file and running that file through Command
> Line Processor we get an error about not being able to find nmake.
>
> Does this mean we also have to have a C compiler ? Is there any
> documentation how to set the environment for creating stored procedures up?
>
> Thanks for any help.
>
> Best regards,
> Kovi

[Jean-Marc Blaise]

"Gregor Kovaè" <gregor.kovac@mikropis.si> a écrit dans le message de
news:vTlab.3225$2B6.645451@news.siol.net...

> Hi!
>
> We are using DB2 8.1 with FixPack 3 on Windows 2000 Server.
>
> We want to use stored procedures with our database, but when creating a
> simple stored procedure in a file and running that file through Command
> Line Processor we get an error about not being able to find nmake.
>
> Does this mean we also have to have a C compiler ? Is there any
> documentation how to set the environment for creating stored procedures

up?

>
> Thanks for any help.
>
> Best regards,
> Kovi

Hi Kovi,

Yes you have to use a C compiler, that is Microsoft Visual C++.

But you also might try gcc; you can have a look to
[url]http://www7b.software.ibm.com/dmdd/library/techarticle/0306haungs/0306haungs.html[/url]
that describes how to use GCC (at least for stored procs, not the samples
....)

Cheers,

Jean-Marc

[No Body]

Gregor Kovac( wrote:

> Hi!
>
> We are using DB2 8.1 with FixPack 3 on Windows 2000 Server.
>
> We want to use stored procedures with our database, but when creating a
> simple stored procedure in a file and running that file through Command
> Line Processor we get an error about not being able to find nmake.
>
> Does this mean we also have to have a C compiler ? Is there any
> documentation how to set the environment for creating stored procedures up?
>
> Thanks for any help.
>
> Best regards,
> Kovi

Yes, you will need a C compiler. It's documented in detail in the
application build guide.

[Jean-Marc Blaise]

Hi Larry,

I still consider this is a workaround (put routine/get routine). Just apply
a fixpack on dev or integration, and you might have to wait before applying
it to prod. Does this mean you should stop deploying stored procs ?

Can we expect GNU be fully supported by IBM ?

Regards,

Jean-Marc

"Larry Edelstein" <lsedels@us.ibm.com> a écrit dans le message de
news:3F69F265.7D8A50B@us.ibm.com...

> If you are using SQL Stored Procs, you need a C Compiler on at least one
> machine with each os level/db2level. You can move the executables to other
> machines with the same os level/db2level. See the Application Building

Guide.

>
> Larry Edelstein
>
> Gregor Kovaè wrote:
>

> > Hi!
> >
> > We are using DB2 8.1 with FixPack 3 on Windows 2000 Server.
> >
> > We want to use stored procedures with our database, but when creating a
> > simple stored procedure in a file and running that file through Command
> > Line Processor we get an error about not being able to find nmake.
> >
> > Does this mean we also have to have a C compiler ? Is there any
> > documentation how to set the environment for creating stored procedures

up?

> >
> > Thanks for any help.
> >
> > Best regards,
> > Kovi

>

[Blair Adamache]

You're right - we are working to remove the requirement for a compiler.

Apologies if it's been cited before, but an article showing you how to
use GCC is here:

[url]http://www7b.boulder.ibm.com/dmdd/library/techarticle/0306haungs/0306haungs.html[/url]

Jean-Marc Blaise wrote:

> Hi Larry,
>
> I still consider this is a workaround (put routine/get routine). Just apply
> a fixpack on dev or integration, and you might have to wait before applying
> it to prod. Does this mean you should stop deploying stored procs ?
>
> Can we expect GNU be fully supported by IBM ?
>
> Regards,
>
> Jean-Marc
>
> "Larry Edelstein" <lsedels@us.ibm.com> a écrit dans le message de
> news:3F69F265.7D8A50B@us.ibm.com...
>

>>If you are using SQL Stored Procs, you need a C Compiler on at least one
>>machine with each os level/db2level. You can move the executables to other
>>machines with the same os level/db2level. See the Application Building

>
> Guide.
>

>>Larry Edelstein
>>
>>Gregor Kovaè wrote:
>>
>>

>>>Hi!
>>>
>>>We are using DB2 8.1 with FixPack 3 on Windows 2000 Server.
>>>
>>>We want to use stored procedures with our database, but when creating a
>>>simple stored procedure in a file and running that file through Command
>>>Line Processor we get an error about not being able to find nmake.
>>>
>>>Does this mean we also have to have a C compiler ? Is there any
>>>documentation how to set the environment for creating stored procedures

>
> up?
>

>>>Thanks for any help.
>>>
>>>Best regards,
>>> Kovi

>>

>
>

[Jean-Marc Blaise]

Hi Blair,

The article you refer for GCC is only for compiling stored procs ... and you
cannot even debug them with the Dev Center.
I have also tried to compile the samples with this GCC, seems to compile,
but most of the exe abort on Windows.

Can we expect a full support of GCC one day ?

Regards,

Jean-Marc

"Blair Adamache" <badamache@2muchspam.yahoo.com> a écrit dans le message de
news:bko428$k9v$2@hanover.torolab.ibm.com...

> You're right - we are working to remove the requirement for a compiler.
>
> Apologies if it's been cited before, but an article showing you how to
> use GCC is here:
>
>

[url]http://www7b.boulder.ibm.com/dmdd/library/techarticle/0306haungs/0306haungs.html[/url]

>
> Jean-Marc Blaise wrote:
>

> > Hi Larry,
> >
> > I still consider this is a workaround (put routine/get routine). Just

apply

> > a fixpack on dev or integration, and you might have to wait before

applying

> > it to prod. Does this mean you should stop deploying stored procs ?
> >
> > Can we expect GNU be fully supported by IBM ?
> >
> > Regards,
> >
> > Jean-Marc
> >
> > "Larry Edelstein" <lsedels@us.ibm.com> a écrit dans le message de
> > news:3F69F265.7D8A50B@us.ibm.com...
> >

> >>If you are using SQL Stored Procs, you need a C Compiler on at least one
> >>machine with each os level/db2level. You can move the executables to

other

> >>machines with the same os level/db2level. See the Application Building

> >
> > Guide.
> >

> >>Larry Edelstein
> >>
> >>Gregor Kovaè wrote:
> >>
> >>
> >>>Hi!
> >>>
> >>>We are using DB2 8.1 with FixPack 3 on Windows 2000 Server.
> >>>
> >>>We want to use stored procedures with our database, but when creating a
> >>>simple stored procedure in a file and running that file through Command
> >>>Line Processor we get an error about not being able to find nmake.
> >>>
> >>>Does this mean we also have to have a C compiler ? Is there any
> >>>documentation how to set the environment for creating stored procedures

> >
> > up?
> >

> >>>Thanks for any help.
> >>>
> >>>Best regards,
> >>> Kovi
> >>

> >
> >

>

[Blair Adamache]

I expect we'll remove the need for a C compiler for SQL stored
procedures before we support GCC.

Jean-Marc Blaise wrote:

> Hi Blair,
>
> The article you refer for GCC is only for compiling stored procs ... and you
> cannot even debug them with the Dev Center.
> I have also tried to compile the samples with this GCC, seems to compile,
> but most of the exe abort on Windows.
>
> Can we expect a full support of GCC one day ?
>
> Regards,
>
> Jean-Marc
>
> "Blair Adamache" <badamache@2muchspam.yahoo.com> a écrit dans le message de
> news:bko428$k9v$2@hanover.torolab.ibm.com...
>

>>You're right - we are working to remove the requirement for a compiler.
>>
>>Apologies if it's been cited before, but an article showing you how to
>>use GCC is here:
>>
>>

>
> [url]http://www7b.boulder.ibm.com/dmdd/library/techarticle/0306haungs/0306haungs.html[/url]
>

>>Jean-Marc Blaise wrote:
>>
>>

>>>Hi Larry,
>>>
>>>I still consider this is a workaround (put routine/get routine). Just

>
> apply
>

>>>a fixpack on dev or integration, and you might have to wait before

>
> applying
>

>>>it to prod. Does this mean you should stop deploying stored procs ?
>>>
>>>Can we expect GNU be fully supported by IBM ?
>>>
>>>Regards,
>>>
>>>Jean-Marc
>>>
>>>"Larry Edelstein" <lsedels@us.ibm.com> a écrit dans le message de
>>>news:3F69F265.7D8A50B@us.ibm.com...
>>>
>>>
>>>>If you are using SQL Stored Procs, you need a C Compiler on at least one
>>>>machine with each os level/db2level. You can move the executables to

>
> other
>

>>>>machines with the same os level/db2level. See the Application Building
>>>
>>>Guide.
>>>
>>>
>>>>Larry Edelstein
>>>>
>>>>Gregor Kovaè wrote:
>>>>
>>>>
>>>>
>>>>>Hi!
>>>>>
>>>>>We are using DB2 8.1 with FixPack 3 on Windows 2000 Server.
>>>>>
>>>>>We want to use stored procedures with our database, but when creating a
>>>>>simple stored procedure in a file and running that file through Command
>>>>>Line Processor we get an error about not being able to find nmake.
>>>>>
>>>>>Does this mean we also have to have a C compiler ? Is there any
>>>>>documentation how to set the environment for creating stored procedures
>>>
>>>up?
>>>
>>>
>>>>>Thanks for any help.
>>>>>
>>>>>Best regards,
>>>>> Kovi
>>>>
>>>

>
>