Binding CLI Packages for Distributed Applications Using Dynamic S QL

Gerry McHugh

Binding CLI Packages for Distributed Applications Using Dynamic S QL

December 19, 2000 01:09 PM

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).