Sample SQL statements for installing DB2-supplied routines

DSNTIJRT uses the full template data definition language to create DB2®-supplied routines and supporting objects, and bind statements for creating related packages. In earlier versions of DB2, the data definition language for creating and granting access to DB2-supplied routines and related objects, and the commands for binding packages, was provided as in-stream input processed by a number of installation jobs. In DB2 10, those statements are removed, but DSNTESR enables users to view the full SQL statements if necessary. In DSNTESR, if a routine has a package, the command to bind that package appears immediately after the CREATE statement from that routine.