SQL Procedures (PSM) in V6

Joe Luthman

SQL Procedures (PSM) in V6
I've consulted the redbook on SQL Procedures and have two questions.

1) How does one install SQL Procedures onto V6? The redbook addresses only V5.

2) When will a supported SQL Procedures for V6 be announced? What we seem to have now, for V5, is a use-at-your-own-risk product. I'd prefer to wait until an announced FMID(s) or PTF(s).
Joe Luthman
DBA Information Technology Services
Phone: (419)372-7750 260 Hayes Hall
FAX: (419)372-7723 Bowling Green State University
E-Mail: [login to unmask email] Bowling Green, OH 43403



Philip Gunning

Re: SQL Procedures (PSM) in V6
(in response to Joe Luthman)
Joe, If you are talking about Stored Procedures, there is detailed
informaiton in the V5 and V6 Application Programming and SQL Guide
SC26-8958-00, and in the redbook. If you are talking about SQL Procedural
Language, I do not know of any support in V5 for OS/390 but I know it is
coming, not sure if in V6.1 or not. HTH Phil

Philip K. Gunning
DB2 DBA
IBM Certified Solutions Expert -- DB2 UDB
IBM Cetfified Solutions Expert -- CICS TS
Assoc List Owner

-----Original Message-----
From: Joe Luthman [SMTP:[login to unmask email]
Sent: Friday, December 24, 1999 7:13 AM
To: [login to unmask email]
Subject: SQL Procedures (PSM) in V6

I've consulted the redbook on SQL Procedures and have two questions.

1) How does one install SQL Procedures onto V6? The redbook addresses only
V5.

2) When will a supported SQL Procedures for V6 be announced? What we seem
to have now, for V5, is a use-at-your-own-risk product. I'd prefer to wait
until an announced FMID(s) or PTF(s).
Joe Luthman
DBA Information Technology Services
Phone: (419)372-7750 260 Hayes Hall
FAX: (419)372-7723 Bowling Green State University
E-Mail: [login to unmask email] Bowling Green, OH 43403








Roger Miller

Re: SQL Procedures (PSM) in V6
(in response to Philip Gunning)
1) I think that the items that need APARs are out, but some probably do not
have the PTFs available yet. Here is one of the better notes from Susan
Malaika.


The Preview of SQL Procedures mainly documents the SQL Procedures

language on DB2 OS/390.

It does not describe the Stored Procedure Builder in any detail.



The V6 version of the manual is not available on the Internet yet

because:

- we have not completed testing V6 SQL Procedures on OS/390

with the Stored Procedure Builder

- nor have we shipped all the V6 APARs required to create SQL

Procedures using the Stored Procedure Builder



The V6 manual draft is available on the Intranet at:

http://malaika4.stl.ibm.com/stl/db2/psm/psmv6_dec1999.pdf

Comments are most welcome.


The life of this manual is short, as the material will be integrated

into existing DB2 documentation {SQL Procedures is an extension of

the SQL language, and hence will be described in the existing DB2

SQL documentation}



I include below a list of relevant V6 APARs some of which have

not shipped yet. I hope this information helps.



Susan Malaika



--------------------------------------------------------------------------

****To create, drop, compile and run SQL procedures using JCL

PQ29782 (PTF=UQ34840) and PQ30467 (PTF=UQ34841) ... available now

PQ33026 and PQ33560 for issuing improved syntax error messages

and other extensions



****Additional functions for SQL Procedures

- Savepoint support PQ30439 (PTF=UQ35648) ... available now

- Identities PQ30684 and PQ30652

- Temp tables - PQ32670


***To develop SQL Procedures on OS/390 using Stored Procedure Builder
-Rexx feature - Web download beta
-Rexx Stored Procedure - PQ30219 (PTF=UQ35973 )Available now
PQ33132 and PQ33133
-Bind changes - PQ24199
-Install, samples & SQL Procedure Processor DSNTPSMP PQ30492


2) For V6, at least one of the pieces requires that we have an announcement
and
have a new feature. By the time the packaging, testing and announcement is
done, the best guess is the end of March. Until then, there is the
download.

Roger Miller


Joe Luthman <[login to unmask email]>@RYCI.COM> on 12/24/99 07:13:13 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: SQL Procedures (PSM) in V6



I've consulted the redbook on SQL Procedures and have two questions.

1) How does one install SQL Procedures onto V6? The redbook addresses only
V5.

2) When will a supported SQL Procedures for V6 be announced? What we seem
to have now, for V5, is a use-at-your-own-risk product. I'd prefer to wait
until an announced FMID(s) or PTF(s).
Joe Luthman
DBA Information Technology Services
Phone: (419)372-7750 260 Hayes Hall
FAX: (419)372-7723 Bowling Green State University
E-Mail: [login to unmask email] Bowling Green, OH 43403








stan park

Re: SQL Procedures (PSM) in V6
(in response to Roger Miller)
Roger,
Could not resolve the hostname ( malaika4.stl.ibm.com )
-Stan


-----Original Message-----
From: Roger Miller [mailto:[login to unmask email]
Sent: Monday, December 27, 1999 9:50 AM
To: [login to unmask email]
Subject: Re: SQL Procedures (PSM) in V6


1) I think that the items that need APARs are out, but some probably do not
have the PTFs available yet. Here is one of the better notes from Susan
Malaika.


The Preview of SQL Procedures mainly documents the SQL Procedures

language on DB2 OS/390.

It does not describe the Stored Procedure Builder in any detail.



The V6 version of the manual is not available on the Internet yet

because:

- we have not completed testing V6 SQL Procedures on OS/390

with the Stored Procedure Builder

- nor have we shipped all the V6 APARs required to create SQL

Procedures using the Stored Procedure Builder



The V6 manual draft is available on the Intranet at:

http://malaika4.stl.ibm.com/stl/db2/psm/psmv6_dec1999.pdf

Comments are most welcome.


The life of this manual is short, as the material will be integrated

into existing DB2 documentation {SQL Procedures is an extension of

the SQL language, and hence will be described in the existing DB2

SQL documentation}



I include below a list of relevant V6 APARs some of which have

not shipped yet. I hope this information helps.



Susan Malaika



--------------------------------------------------------------------------

****To create, drop, compile and run SQL procedures using JCL

PQ29782 (PTF=UQ34840) and PQ30467 (PTF=UQ34841) ... available now

PQ33026 and PQ33560 for issuing improved syntax error messages

and other extensions



****Additional functions for SQL Procedures

- Savepoint support PQ30439 (PTF=UQ35648) ... available now

- Identities PQ30684 and PQ30652

- Temp tables - PQ32670


***To develop SQL Procedures on OS/390 using Stored Procedure Builder
-Rexx feature - Web download beta
-Rexx Stored Procedure - PQ30219 (PTF=UQ35973 )Available now
PQ33132 and PQ33133
-Bind changes - PQ24199
-Install, samples & SQL Procedure Processor DSNTPSMP PQ30492


2) For V6, at least one of the pieces requires that we have an announcement
and
have a new feature. By the time the packaging, testing and announcement is
done, the best guess is the end of March. Until then, there is the
download.

Roger Miller


Joe Luthman <[login to unmask email]>@RYCI.COM> on 12/24/99 07:13:13 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: SQL Procedures (PSM) in V6



I've consulted the redbook on SQL Procedures and have two questions.

1) How does one install SQL Procedures onto V6? The redbook addresses only
V5.

2) When will a supported SQL Procedures for V6 be announced? What we seem
to have now, for V5, is a use-at-your-own-risk product. I'd prefer to wait
until an announced FMID(s) or PTF(s).
Joe Luthman
DBA Information Technology Services
Phone: (419)372-7750 260 Hayes Hall
FAX: (419)372-7723 Bowling Green State University
E-Mail: [login to unmask email] Bowling Green, OH 43403













Roger Miller

Re: SQL Procedures (PSM) in V6
(in response to stan park)


Sorry - that's inside our IBM firewall. Here is a pdf file.

(See attached file: psmv6_dec1999.pdf)

Roger Miller
Attachments

  • psmv6_dec1999.pdf (433.8k)