Hi Ed
There is no listed entry for SPs and UDFs in the SQL Limits in the V8
Information Center.
However the maximum text length is 2Mb ( SYSCAT.ROUTINES, column TEXT).
What is much more interesting is why you ask the question? Or why a
competent programmer would ever think of approaching such a limit?
My regards to Commissioner John L. Winn

Alex Levy
Sustainable Software Ltd
http://www.sustainablesoftware.net

-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x36227333.[Email address protected]
Sent: 11 December 2006 21:49
To: LazyDBA Discussion
Subject: DB2 Version 8.2, Fixpack 7, for Windows (Size of SQL Stored
Procedure and SQL Stored Function)


To All,
Does anyone know the maximum size of a SQL stored procedure and the
maximum size of a SQL stored function for DB2 version 8.2, Fixpack 7,
for Windows? Thanks.


Please take a few minutes to provide feedback on the quality of service you
received. The Department of Education values your feedback as a customer.
Commissioner John L. Winn is committed to continuously assessing and
improving the level and quality of services provided to you by Department
staff. Simply use the link below. Thank you in advance for completing the
survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------------
Scanned by 186k-NetCleanse, spam and virus protection



DB2 & UDB email list listserv db2-l LazyDBA home page