You must ensure that suitable ODBC data sources have been created on the system on which the broker is running. If you have used the mqsisetdbparms command to set a user ID and password for a particular database, the broker uses these values to connect to the database. If you have not set a user ID and password, the broker uses the default database user ID and password that you supplied on the mqsicreatebroker command (as modified by any subsequent mqsichangebroker commands).
On z/OS systems, use the JCL member
BIPSDBP in the customization data set <hlq>.SBIPPROC to
perform the mqsisetdbparms command.
You must also ensure that the database user IDs have sufficient privileges to perform the operations your flow requires. Otherwise errors will occur at runtime.
Select the Throw exception on database error property check box and the Treat warnings as errors property check box, and set the Transaction property to Automatic, to provide maximum flexibility. You can then use the COMMIT and ROLLBACK statements for transaction control, and create handlers for dealing with errors.
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak05800_ |