Re: What does a *SQLPKG do?

[Dan <dan27649@xxxxxxxxx>]

Good find, Mark!

I find it curious that you can use the INSERT, DELETE, and UPDATE
statements, but not the MERGE statement.

The linked document makes no mention of the CRTSQLPKG command.  From the
limited information in the help text:
> > >

The Create Structured Query Language Package (CRTSQLPKG) command allows you
to create (or re-create) an SQL package on a relational database from an
existing distributed SQL program.  A distributed SQL program is a program
created by specifying the Relational database (RDB) parameter on a
CRTSQLxxx (where xxx = CBL, CBLI, CI, CPPI, PLI, RPG or RPGI) command.

<<<

> From this, it seems that the default RDB(*LOCAL) parameter qualifies a
program to be used in a CRTSQLPKG command.  How does one go about using an
*SQLPKG object?  From what I can tell from the linked document, it appears
that performance gains could be realized from using one.


- Dan



On Thu, Apr 13, 2017 at 3:12 PM, Mark S Waterbury <
mark.s.waterbury@xxxxxxxxxxxxx> wrote:

> Justin:
>
> See:
>     http://www-01.ibm.com/support/docview.wss?uid=nas8N1019633
>
> for an explanation of what *SQLPKGs are used for.