SQL Stored Procedures Compile Proc

Kate Bloom

SQL Stored Procedures Compile Proc
Hello,

We have DB2 V8 on z/OS 1.7, z/OS XL C/C++ compiler. I need to setup SQL Stored Procedures compile proc. I am a DB2 novice, does anyone have a sample I can look at or know where I can find one? Thanks.

Kate





---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

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

Avram Friedman

Re: SQL Stored Procedures Compile Proc
(in response to Kate Bloom)
When your shop installed or migrated to V8, DB2 generated the proc for C++
compiles.

As it happens, in many shops, the job that puts the PROCS in a PROCLIB is not
run for various reasons.
Here are the clues you need

The procname is DSNHCPP
Just run a job with an EXEC card that says
//FINDIT EXEC DSNHCPP
and see if it finds the proc ... with out any overrides it will JCL out but you will
know if it is out there.


If it is not out there here are the questions you need to ask your systems
programmer
1. Does the NEW.SDSNSAMP job from the DB2 V8 install or DB2 V8 CM
migration still exist? If it does can he/she extract PROC DSNHCPP from
member DSNTIJMV

2. If the NEW.SDSNSAMP does not exist the same PROC can be extracted
from the same member in the SMPE target lib SDSNSAMP however this copy
will require additional editing to conform to your shops naming conventions.


If you have complex change control this is what I suggest
Have the systems programmer run the step in DSNTIJMV that builds the procs
but override the output to a private user dataset. Then the PROCS can be
tested and modified if required by adding the following card before the first
EXEC in a job

//MYPROCS JCLLIB ORDER=(my.private.dsn)
where my.private.dsn is the play dataset that the systems programmer loaded
the PROCS to.

Best Wishes
Avram Friedman

On Thu, 13 Dec 2007 11:55:38 -0800, Kate Bloom <[login to unmask email]>
wrote:

>Hello,
>
> We have DB2 V8 on z/OS 1.7, z/OS XL C/C++ compiler. I need to setup
SQL Stored Procedures compile proc. I am a DB2 novice, does anyone have a
sample I can look at or know where I can find one? Thanks.
>
> Kate
>
>
>
>
>
>---------------------------------
>Looking for last minute shopping deals? Find them fast with Yahoo! Search.
>
>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

Kate Bloom

Re: SQL Stored Procedures Compile Proc
(in response to Avram Friedman)
Thanks much Avram. I will check out the clues you suggested.

Kate


Avram Friedman <[login to unmask email]> wrote:
When your shop installed or migrated to V8, DB2 generated the proc for C++
compiles.

As it happens, in many shops, the job that puts the PROCS in a PROCLIB is not
run for various reasons.
Here are the clues you need

The procname is DSNHCPP
Just run a job with an EXEC card that says
//FINDIT EXEC DSNHCPP
and see if it finds the proc ... with out any overrides it will JCL out but you will
know if it is out there.


If it is not out there here are the questions you need to ask your systems
programmer
1. Does the NEW.SDSNSAMP job from the DB2 V8 install or DB2 V8 CM
migration still exist? If it does can he/she extract PROC DSNHCPP from
member DSNTIJMV

2. If the NEW.SDSNSAMP does not exist the same PROC can be extracted
from the same member in the SMPE target lib SDSNSAMP however this copy
will require additional editing to conform to your shops naming conventions.


If you have complex change control this is what I suggest
Have the systems programmer run the step in DSNTIJMV that builds the procs
but override the output to a private user dataset. Then the PROCS can be
tested and modified if required by adding the following card before the first
EXEC in a job

//MYPROCS JCLLIB ORDER=(my.private.dsn)
where my.private.dsn is the play dataset that the systems programmer loaded
the PROCS to.

Best Wishes
Avram Friedman

On Thu, 13 Dec 2007 11:55:38 -0800, Kate Bloom
wrote:

>Hello,
>
> We have DB2 V8 on z/OS 1.7, z/OS XL C/C++ compiler. I need to setup
SQL Stored Procedures compile proc. I am a DB2 novice, does anyone have a
sample I can look at or know where I can find one? Thanks.
>
> Kate
>
>
>
>
>
>---------------------------------
>Looking for last minute shopping deals? Find them fast with Yahoo! Search.
>
>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



---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

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