SQL functions and procedures

Functions and procedures, both SQL and external, are eligible for replication.

For external functions and procedures, replication requires the external program or service program object to be included in replication. Replication is not associated with the function or procedure name.

For a Java™ routine, you must maintain the class file or jar file used by Java routine on both nodes if the file is not stored in an IFS IASP.

If an object referenced in a default value for a routine parameter does not exist on both nodes, the routine will fail to create.