My Oracle Support Banner

E1: DB: OS: AS400 iSeries SQL Packages Frequently Asked Questions and Answers (Doc ID 1602140.1)

Last updated on NOVEMBER 13, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
IBM i on POWER Systems

Purpose

Frequently Asked Questions about AS400 iSeries SQL Packages. This document complements information found in <Document 1525639.1> - E1: OS: Overview, Maintenance and Known Issues for AS400 SQLPkgs.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Q: What are SQL packages?
 Q: When do SQL packages get created?
 Q: How are SQL packages named?
 Q: What library does the SQL package go into? Is there a preferred library for SQL packages?
 Q: What are the advantages of using SQL packages?
 Q: Do all prepared statements go into an SQL package?
 Q: How can I tell what statements are in an SQL package?
 Q: Can the same statement appear multiple times in the same SQL package?
 Q: How can I tell if the SQL package is being used?
 Q: What data is stored in an SQL package?
 Q: How big is an SQL package?
 Q: Are there any performance considerations for the new, bigger packages?
 Q: Is there an optimal size for bigger packages?
 Q: Are there any plans to support bigger packages in releases prior to V4R3?
 Q: What happens when SQL packages get full?
 Q: Are there other times when an SQL package can become unusable?
 Q: When should I delete SQL packages?
 Q: How do I delete SQL packages?
 Q: Why would service personnel recommend deleting SQL packages? Are they corrupted?
 Q: Why can't I delete a package with a name of _CSETUP (or other nonstandard system object names)?
 Q: What are the QSQLPKG and QSQXDPKG packages in QSYS for? Can they be deleted?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.