Re: What does a *SQLPKG do?

[Mark S Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>]

Justin:

See:
    http://www-01.ibm.com/support/docview.wss?uid=nas8N1019633

for an explanation of what *SQLPKGs are used for.

HTH,

Mark S. Waterbury

> On 4/11/2017 11:45 AM, Justin Taylor wrote:
> I have a client creating *SQLPKG objects, and I need to know what they do.  The IBM docs recommend PRTSQLINF, but that doesn't seem to tell me what it actually does.
>
>
> Here's a sample of the output from PRTSQLINF:
> Object name...............QGPL/SSMSAFBA
> Object type...............*SQLPKG
>    CRTSQL***
>        PGM(QGPL/SSMSAFBA)
>        SRCFILE(          /          )
>        SRCMBR(          )
>        COMMIT(*NONE)
>        OPTION(*SQL *EXTIND   *PERIOD)
>        TGTRLS(*PRV)
>        ALWCPYDTA(*OPTIMIZE)
>        CLOSQLCSR(*ENDPGM)
>        DECRESULT(31 31 0)
>        STATEMENT TEXT CCSID(37)