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




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