Binding CLI Packages for Distributed Applications Using Dynamic S QL

Gerry McHugh

Binding CLI Packages for Distributed Applications Using Dynamic S QL
Trying to confirm whether an assumption I'm under is correct. We're using
DB2 Connect to connect to the mainframe. It's my understanding that when
binding the CLI packages in DB2/OS390, you cannot specify
"DYNAMICRULES(BIND)" as a bind option, because (according to the Command
Reference Manual) this option cannot be used for binding packages that would
include SQL statements that cannot be dynamically prepared. This would
include, amoung other things, "SET CURRENT PACKAGESET" and "CONNECT".
Unless I'm missing something, any web or client server application program
accessing DB2/OS390 is going to execute the CONNECT statement, thereby
eliminating the option of binding the CLI packages with DYNAMICRULES(BIND).