Sample SQL statements for installing Db2-supplied routines
Sample member DSNTESR contains samples of the SQL statements and commands that are used by the DSNTIJRT job to create Db2-supplied routines.
The DSNTESR member in the prefix.SDNSAMP data set contains samples that illustrate the statements and commands that are issued when you run the DSNIJRT job to execute the DSNTRIN program, including the following statements and commands:
- Data definition (DDL) statements for dropping and creating the Db2-supplied routines and related objects
- Data control (DCL) statements for granting access to the Db2 routines and related objects
- Commands for binding packages of the Db2-supplied routines
For more information, see Job DSNTIJRT.
The DSNTIJRT job is used for the following tasks when you install, migrate, or configure a Db2 environment: