CONNX Data Integration Suite 14.8.0 | Operations Guide | Working with Database Objects in CONNX | CONNX and DB2 | DB2/OS400 | Dynamic SQL Package Security
 
Dynamic SQL Package Security
To build the dynamic SQL packages required by CONNX, your OS/400 user ID requires write access to the target library/collection (default = NULLID), plus the BIND and GRANT privileges. The last step in the package-building logic is a
GRANT execute to library.CONX???? to PUBLIC
where:
*library is the target library/collection (default = NULLID)
*???? is the package suffix as documented in CONNX Db2 Dynamic SQL Packages