If you are using dynamic SQL, you won't see it in the PRTSQLINF printer file
The SQL package includes the access plans for static or extended dynamic SQL
statements.
The access plans are used for validation, ... but with the SQE access plans
are first searched in the SQE Plan Cache (independent whether the SQL
statements are static or dynamic).
If there is no access plan found, the SQL package is searched. If an access
plan is found, it is validated.
If access plan is found, it is created by scratch.
In (embedded) SQL (Service-)Programs, the access plans for static SQL are
automatically included and updated, i.e. the SQL package is included.
With PRTSQLINF, you'll get information about the access plans.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Justin Taylor
Sent: Montag, 17. April 2017 21:38
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: What does a *SQLPKG do?
I ran this command against a known SQLRPGLE object:
CRTSQLPKG PGM(&1) OBJTYPE(*SRVPGM)
The printed output gave the SQL commands. I then created a SQLPKG for that
service program and ran:
CRTSQLPKG PGM(&1) OBJTYPE(*SQLPKG)
That gave the same output as the first command.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
