SQL Stored Procedures and the C compiler

Philip Sevetson

SQL Stored Procedures and the C compiler
I just had a nasty surprise; apparently the C (C++?) compiler is not
included with DB2 V8 for z/OS. This creates a cost for using SQL Stored
Procedures - you have to buy the compiler for the SQL Stored Procedures
to run.



IBM People on the list, does my boss have this right? And if so, why
has IBM decided to "slip in" this additional cost for DB2?



Thanks!



--Phil Sevetson, NYCAPS DBA Support

Financial Information Services Agency of The City of New York

450 West 33rd Street, 4th Floor

New York, NY 10001

phone: (212) 857-1688

mailto: [login to unmask email] <mailto:[login to unmask email]>





=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Steve Grimes

Re: SQL Stored Procedures and the C compiler
(in response to Philip Sevetson)
I didn't know it was included pre-v8.

We only run COBOL SP's for this reason. (It was the only compiler we had
around.)

I've heard that V9 does not have the C compiler requirement. I'm sure
someone will confirm/deny.

Stg





"Sevetson, Phil" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/07/2008 03:33 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] SQL Stored Procedures and the C compiler






I just had a nasty surprise; apparently the C (C++?) compiler is not
included with DB2 V8 for z/OS. This creates a cost for using SQL Stored
Procedures – you have to buy the compiler for the SQL Stored Procedures to
run.

IBM People on the list, does my boss have this right? And if so, why has
IBM decided to “slip in” this additional cost for DB2?

Thanks!

--Phil Sevetson, NYCAPS DBA Support
Financial Information Services Agency of The City of New York
450 West 33rd Street, 4th Floor
New York, NY 10001
phone: (212) 857-1688
mailto: [login to unmask email]

=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use of
the recipient(s) named above. If you are not an intended recipient, or the
employee or agent responsible to deliver it to an intended recipient, you
are hereby notified that you have received this communication in error and
that any review, disclosure, dissemination, distribution or copying of it
or its contents is prohibited. If you have received this communication in
error, please notify me immediately by replying to this message and delete
this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or the
City.
=========


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org under
the Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services

Renu Sharma

Re: SQL Stored Procedures and the C compiler
(in response to Steve Grimes)
Yes that's correct even for 8 also u don't require C compiler


Renu



**************Start the year off right. Easy ways to stay in shape.
http://body.aol.com/fitness/winter-exercise?NCID=aolcmp00300000002489

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Renu Sharma

Re: SQL Stored Procedures and the C compiler
(in response to Renu Sharma)
I am sorry I thought we were discussing db2 udb on LUW


Renu



**************Start the year off right. Easy ways to stay in shape.
http://body.aol.com/fitness/winter-exercise?NCID=aolcmp00300000002489

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Myron Miller

Re: SQL Stored Procedures and the C compiler
(in response to Renu Sharma)
As far as I know, you don't have to buy the C compiler. We didn't and IBM has
not seen any problems with that.
--- "Sevetson, Phil" <[login to unmask email]> wrote:

> I just had a nasty surprise; apparently the C (C++?) compiler is not
> included with DB2 V8 for z/OS. This creates a cost for using SQL Stored
> Procedures - you have to buy the compiler for the SQL Stored Procedures
> to run.
>
>
>
> IBM People on the list, does my boss have this right? And if so, why
> has IBM decided to "slip in" this additional cost for DB2?
>
>
>
> Thanks!
>
>
>
> --Phil Sevetson, NYCAPS DBA Support
>
> Financial Information Services Agency of The City of New York
>
> 450 West 33rd Street, 4th Floor
>
> New York, NY 10001
>
> phone: (212) 857-1688
>
> mailto: [login to unmask email] <mailto:[login to unmask email]>
>
>
>
>
>
> =========
> Confidentiality Notice: This e-mail communication, and any attachments,
> contains confidential and privileged information for the exclusive use of the
> recipient(s) named above. If you are not an intended recipient, or the
> employee or agent responsible to deliver it to an intended recipient, you are
> hereby notified that you have received this communication in error and that
> any review, disclosure, dissemination, distribution or copying of it or its
> contents is prohibited. If you have received this communication in error,
> please notify me immediately by replying to this message and delete this
> communication from your computer. Thank you.
>
> Any opinions, expressed or implied, presented are solely those of the author
> and do not necessarily represent the opinions of the agency or the City.
> =========
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
> archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
> under the Listserv tab. While at the site, you can also access the IDUG
> Online Learning Center, Tech Library and Code Place, see the latest IDUG
> conference information, and much more. If you have not yet signed up for
> Basic Membership in IDUG, available at no cost, click on Member Services at
> http://www.idug.org/lsms
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

[login to unmask email]

Re: SQL Stored Procedures and the C compiler
(in response to Myron Miller)
Your boss has this right.

In DB2 9 you don't need a separate c compiler (or license) anymore.

Groeten,
Bart

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sevetson, Phil
Sent: Monday, January 07, 2008 10:34 PM
To: [login to unmask email]
Subject: [DB2-L] SQL Stored Procedures and the C compiler



I just had a nasty surprise; apparently the C (C++?) compiler is not
included with DB2 V8 for z/OS. This creates a cost for using SQL Stored
Procedures - you have to buy the compiler for the SQL Stored Procedures
to run.



IBM People on the list, does my boss have this right? And if so, why
has IBM decided to "slip in" this additional cost for DB2?



Thanks!



--Phil Sevetson, NYCAPS DBA Support

Financial Information Services Agency of The City of New York

450 West 33rd Street, 4th Floor

New York, NY 10001

phone: (212) 857-1688

mailto: [login to unmask email] <mailto:[login to unmask email]>



________________________________

=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use
of the recipient(s) named above. If you are not an intended recipient,
or the employee or agent responsible to deliver it to an intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you have
received this communication in error, please notify me immediately by
replying to this message and delete this communication from your
computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or
the City.
=========


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < http://www.idug.org/lsms >
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

M. Khalid Khan

Re: SQL Stored Procedures and the C compiler
(in response to Bart.Mertens@MAIL.ING.NL)
I don't think it was ever "included" but there is still good news ... I
saved a lot of ... oops, just kidding. The good news is that in DB2 9, you
won't need a C compiler at all AND these SQL SP's run in DBM1 rather than
a WLM address space.
Khalid





[login to unmask email]
Sent by: "DB2 Data Base Discussion List" <[login to unmask email]>
01/07/2008 04:06 PM
Please respond to
"DB2 Database Discussion list at IDUG" <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] SQL Stored Procedures and the C compiler







I didn't know it was included pre-v8.

We only run COBOL SP's for this reason. (It was the only compiler we had
around.)

I've heard that V9 does not have the C compiler requirement. I'm sure
someone will confirm/deny.

Stg




"Sevetson, Phil" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/07/2008 03:33 PM

Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] SQL Stored Procedures and the C compiler








I just had a nasty surprise; apparently the C (C++?) compiler is not
included with DB2 V8 for z/OS. This creates a cost for using SQL Stored
Procedures ? you have to buy the compiler for the SQL Stored Procedures to
run.

IBM People on the list, does my boss have this right? And if so, why has
IBM decided to ?slip in? this additional cost for DB2?

Thanks!

--Phil Sevetson, NYCAPS DBA Support
Financial Information Services Agency of The City of New York
450 West 33rd Street, 4th Floor
New York, NY 10001
phone: (212) 857-1688
mailto: [login to unmask email]

=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use of
the recipient(s) named above. If you are not an intended recipient, or the
employee or agent responsible to deliver it to an intended recipient, you
are hereby notified that you have received this communication in error and
that any review, disclosure, dissemination, distribution or copying of it
or its contents is prohibited. If you have received this communication in
error, please notify me immediately by replying to this message and delete
this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or the
City.
=========

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org under
the Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services


**********

The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.

**********

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms