SQL Packages are the objects created at the database end, used to store information about the Prepared SQL statements.They usually contain info about the specs of the database objects,action plan etc.,These sql packages are necessary to improve the performance of the applications doing database operations.
The following link answers the questions related to sql packages like , what is a sql package, when they are created, where , Managing sql packages,exceptions etc.,
The following link answers the questions related to sql packages like , what is a sql package, when they are created, where , Managing sql packages,exceptions etc.,
1)What do sql package contain?
A sql package contain all the necessary information required to execute the sql statement.Namely, the registry of the statement name,the statement text,the internal parse tree for the statement,definitions of all the tables and fields involved in the statement,and the query access plan needed to access the tables at runtime.etc.,
2)How to view info in the sql packages.
Use PRTSQLINF to get a formatted output about the action plan used to access the data.or use iseries navigator to see the plan.
Related
Deleting Sql Packages SQL Packages FAQ
No comments:
Post a Comment