How can I move my SELCOPY DB2 SQL programs from development into production?


As long as the SQLID is the same, the only change required is to connect to a different DB2 subsystem.

This can be done either by using different "OPTION SSN=" parameter in your SELCNAM, including an "OPTION SSN=" card at the start of the SELCOPY code or changing the "SSN=" parameter on the READ operation.