© Copyright, 2002 Howard F. Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
Slide: 40   4/2/2002
Problems with packages
•If your application is using a lot of dynamic SQL, packaging will not help
•Search is done by string length, so AS/400 can miss statements that are the same though they have different lengths
•First optimization can be quite long due to exhaustive search
•To effectively use packages you must use parameterized statements