Size Limits with SQL Packages on IBM i
SQL packages (object type: *SQLPKG) are used with SAP NetWeaver ABAP systems on IBM i. They contain information about SQL statements that are executed within the SAP system. There are limits for the maximum size of these objects and the maximum number of SQL statements that can be in a single SQL package. Usually an algorithm in the SAP database interface ensures that the SQL statements are spread over very many SQL packages, so that the limit is not exceeded. However, in some cases these algorithms do not work very well, which results in SQL0904 (SQL -904) errors. This presentation explains the background of these situations and possible ways to avoid them.