• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

SQL Package

nkassim

Member
B732.1 SP11.3 AS400 Enterprise SQL 6.5

This might be a stupid question but can someone explain to me what are SQL Packages, what are they used for in OneWorld and what type of information in contains.

Thank you for your help in advance

Nageeb
 

graham_jones

Active Member
Nageeb,

Basically my understanding is that they are optimized SQL statements. For
example when you run R98OWSECA security analyzer UBE it creates an object of
type *SQLPKG on the AS/400. Next time the UBE runs it will use this
previously created SQL package. We have had problems with these becoming
corrupted from time to time and have had to delete them to clear the problem
- always being careful not to delete any IBM ones.

You can view them using WRKOBJ *ALL/*ALL *SQLPKG and you can view the
contents using PRTSQLINF QGPL/R98OWSECA *SQLPKG

Hope this helps.

Regards,

Graham.
Graham Jones
JDE Systems Manager
graham.jones@parkgroup.co.uk
0151 653 1700 ext 1109

>
 
Top