[DB2 z/OS v8] Stored Procedures

Larry Jardine

[DB2 z/OS v8] Stored Procedures
Is there a limit to the number of parameters or the combined lengths of
the parameters?

Larry Jardine
Production DBA
TDM Website: http://opsvcs.aetna.com/oltpdb/
This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna

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

Philip Sevetson

Re: [DB2 z/OS v8] Stored Procedures
(in response to Larry Jardine)
Larry,
I found this on a Google search, but it almost certainly is five years
old (and here, in the new millennium, programmers are STILL designing
dates without century indicators...) and doesn't refer to platform or
version.

"Larry Menard 07-15-02, 11:21
Vijay, the 32767 limit is for DARI-style procedures only. For GENERAL
style, the limit is 90.
--
Larry Menard
IBM Workstation Database (DB2) Performance Team"


--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]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jardine, Lawrence J
Sent: Tuesday, December 18, 2007 2:35 PM
To: [login to unmask email]
Subject: [DB2-L] [DB2 z/OS v8] Stored Procedures

Is there a limit to the number of parameters or the combined lengths of
the parameters?

Larry Jardine
Production DBA
TDM Website: http://opsvcs.aetna.com/oltpdb/
This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna

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


=========
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

David Seibert

Re: [DB2 z/OS v8] Stored Procedures
(in response to Philip Sevetson)
Hi Larry,

You probalby know that these types of limits used to reliably found
in Appendix A of the SQL reference for the Version you are using.
Looking there in the DB2 v9 copy, I don't see a limit to the number of
parameters.
All I see is that the maximum number of bytes that can be passed in a
single parameter of an SQL CALL statement is 32765 for a non-LOB and (2
GB-1) for a LOB, possibly limited further by the language and
environment. That doesn't really answer your question.

In the old days before I turned as lazy as I am today, I'd write a Rexx
program to generate and test to see if there might be an undocumented
limit.

Good luck.
Dave


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.

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sevetson, Phil
Sent: Tuesday, December 18, 2007 3:32 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [DB2 z/OS v8] Stored Procedures

Larry,
I found this on a Google search, but it almost certainly is five years
old (and here, in the new millennium, programmers are STILL designing
dates without century indicators...) and doesn't refer to platform or
version.

"Larry Menard 07-15-02, 11:21
Vijay, the 32767 limit is for DARI-style procedures only. For GENERAL
style, the limit is 90.
--
Larry Menard
IBM Workstation Database (DB2) Performance Team"


--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]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jardine, Lawrence J
Sent: Tuesday, December 18, 2007 2:35 PM
To: [login to unmask email]
Subject: [DB2-L] [DB2 z/OS v8] Stored Procedures

Is there a limit to the number of parameters or the combined lengths of
the parameters?

Larry Jardine
Production DBA

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