Program references

 

When a program is created, the i5/OS^® licensed program stores information about all collections, tables, views, SQL packages, and indexes referred to in SQL statements in an SQL program.

You can use the Display Program References (DSPPGMREF) command to display all object references in the program. If the SQL naming convention is used, the library name is stored in one of the following ways:

• If the SQL name is fully qualified, the collection name is stored as the name qualifier.

• If the SQL name is not fully qualified, and the DFTRDBCOL parameter is not specified, the authorization ID of the statement is stored as the name qualifier.

• If the SQL name is not fully qualified, and the DFTRDBCOL parameter is specified, the collection name specified on the DFTRDBCOL parameter is stored as the name qualifier.

If the system naming convention is used, the library name is stored in one of the following ways:

• If the object name is fully qualified, the library name is stored as the name qualifier.

• If the object is not fully qualified, and the DFTRDBCOL parameter is not specified, *LIBL is stored.

• If the SQL name is not fully qualified, and the DFTRDBCOL parameter is specified, the collection name specified on the DFTRDBCOL parameter is stored as the name qualifier.

 

Parent topic:

Testing and debugging

 

Related reference

Display Program References (DSPPGMREF) command