Configure your broker and your
database to support connections from message flows.
- Set the Data Source property
of each node to the name (that is, the ODBC DSN) of the database that
you want to access.
- Configure the broker to be able to connect to the database:
- Create ODBC data source connections on the system on which the
broker is running.
- Define a user ID and password to be used by the broker to connect
to the database:
- If you have used the mqsisetdbparms command, or
submitted the JCL member BIPSDBP in the customization data set <hlq>.SBIPPROC on z/OS®, 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, or
modified by a subsequent mqsichangebroker command (or
the equivalent console command or JCL on z/OS).
- If you have not set a default database user ID and password, the
broker uses its service ID and password.
- Set up the authorization for the user ID to access the database
by using the administration facilities provided by the database vendor.
If you do not do so, the broker generates an error when the message
flow runs.
- All databases accessed from the same node must have the same ODBC
functionality as the database specified on the node's Data Source property. This requirement
is always satisfied if the databases are of the same type (for example, DB2® or Oracle), at the same release
level (for example, release 9.1), and on the same platform. Other
database combinations might have the same ODBC functionality. If a
node tries to access a database that does not have the same ODBC functionality
as the database specified on the node's Data Source property, the broker
issues an error message.
- With a single SELECT FROM clause, you can access
only tables that exist in a single database.
If you access database columns that have names composed
of only numeric characters, you must enclose the names in double quotes;
for example, "0001". Because of this restriction, you cannot use a SELECT
* statement, which returns the names without quotes; the
names are therefore invalid and cause an exception.
For details of the ESQL statements and functions that you
can use to access databases, see Interaction with databases using ESQL.