Save and restore considerations

 

When an external function associated with an ILE external program or service program is created, an attempt is made to save the attributes of the function in the associated program or service program object.

If the *PGM or *SRVPGM object is saved and then restored to this or another system, the catalogs are automatically updated with those attributes. If the function's attribute cannot be saved, then the catalogs will not be automatically updated and the user must create the external function on the new system. The attributes can be saved for external functions subject to the following restrictions:

• The external program library must not be QSYS or QSYS2.

• The external program must exist when the CREATE FUNCTION statement is issued.

• The external program must be an ILE *PGM or *SRVPGM object.

• The external program or service program must contain at least one SQL statement.

If the program object cannot be updated, the function will still be created.

 

Parent topic:

Writing UDFs as external functions