CL Command Reference - CRTSQLPKG
CL Command List > CRTSQLPKG Reference
Description:
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.
Examples:
CRTSQLPKG PGM(PAYROLL) RDB(SYSTEMA) TEXT(¡¯Payroll Program¡¯)
This command creates an SQL package from the distributed SQL program PAYROLL on relational database SYSTEMA.