DB2 z/os SQL stored procs without the C compiler

Scott Hodgin

DB2 z/os SQL stored procs without the C compiler
We just upgraded our DB2 for z/os to V8 CM.



Is the ability to create SQL stored procs for DB2 without needing a C
compiler available in CM or do I have to be in ENFM?



I've tried creating an SQL stored proc on DB2 via Development Center, but it
keeps stopping my WLM on the mainframe.



Scott Hodgin, Database Administrator

South Carolina Farm Bureau Insurance Company

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




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

David Seibert

Re: DB2 z/os SQL stored procs without the C compiler
(in response to Scott Hodgin)
That's not until VNext, Scott.
I think it's in v8.2 for Linux, Unix, & Windows but not until VNext on z/OS.
That's according to Curt's presentation on VNext.

See Roger's links in the NFM/ENFM discussion.

Dave


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Hodgin, Scott
Sent: Friday, January 06, 2006 2:08 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/os SQL stored procs without the C compiler



We just upgraded our DB2 for z/os to V8 CM.



Is the ability to create SQL stored procs for DB2 without needing a C
compiler available in CM or do I have to be in ENFM?



I've tried creating an SQL stored proc on DB2 via Development Center, but it
keeps stopping my WLM on the mainframe.



Scott Hodgin, Database Administrator

South Carolina Farm Bureau Insurance Company

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



----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm