Hi,

I suppose the max length of a stored procedure can be 65576 characters
(approx). If length is an issue, and you cannot reduce it, then you
could split the procedure into two and call the child procedure from
within.


Regards,
Anand




-----Original Message-----
From: Gayanga Alagiyawanna
[mailto:db2udbdba-ezmlmshield-x68621122.[Email address protected]
Sent: Wednesday, February 28, 2007 7:35 AM
To: LazyDBA Discussion
Subject: compliing stored Procedures on iSeriese

Hi All,



I have a problem in compiling stored procedures on the iseries.

It throws up an error message saying



SQL State: 54001
Vendor Code: -99999
Message: SQL statement too long or complex.



But it allows us to compile smaller SP's

I assume there is a problem with the length of the SP

How can I resolve this?



Regards,



Gayanga Alagiyawanna


hSenid Business Solutions (Pvt) Ltd.
Phone: (d):+94-11-5366200 (g):+94-11-4621111

(m): +94-72-2451536 Fax: +94-11-2394064
Web: <BLOCKED::http://www.hsenid.com/> http://www.hSenid.com

Make it happen

Disclaimer: This email and any files transmitted with it are
confidential and intended solely for the use of the individual or entity
to which they are addressed. The content and opinions contained in this
email are not necessarily those of hSenid Business Solutions (Pvt) Ltd.
If you have received this email in error please contact the sender





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




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