The "informix".mqiservice table

The "informix".mqiservice table contains the service definitions for service point (sender/receiver) attributes.

The "informix".mqiservice table has the following schema:

CREATE TABLE "informix".mqiservice
    servicename    LVARCHAR(256), 
    queuemanager   VARCHAR(48) NOT NULL,   
    queuename      VARCHAR(48) NOT NULL, 
    defaultformat  VARCHAR(8) default ' ', 
    ccsid          VARCHAR(6) default ' ', 
    mqconnname     lvarchar(264) default '',
    mqchannelname  varchar(20) default 'SYSTEM.DEF.SVRCONN',
    mqxpt          INTEGER DEFAULT 2  CHECK ( mqxpt >= 0 AND mqxpt <= 6 ),
    mqchllib       lvarchar(512) default '',
    mqchltab       lvarchar(512) default '',
    mqserver       lvarchar(512) default '',
    PRIMARY KEY (servicename) );

The attributes are defined as follows:

servicename: The service name used in the MQ functions.
queuemanager: The queue manager service provider.
queuename: The queue name to send the message to or receive the message from.
defaultformat: Defines the default format.
ccsid: The coded character set identifier of the destination application.
mqconnname: The MQ connection name. This value, which is present only when the client-based messaging library is used, enables the client application to connect to multiple server queue managers simultaneously.
mqchannelname: The MQ channel name. This value, which is present only when the client-based messaging library is used, enables the client application to connect to multiple server queue managers simultaneously.
mqxpt: The MQ transport type attribute. This value, which is present only when the client-based messaging library is used, enables the client application to connect to multiple server queue managers simultaneously.
mqchllib: The MQCHLLIB environment variable of WMQ. This value, which is present only when the client-based messaging library is used, specifies the directory path to the file containing the client channel definition table.
mqchltab: The MQCHLTAB environment variable of WMQ. This value, which is present only when the client-based messaging library is used, specifies the name of the file containing the client channel definition table
mqserver: The MQSERVER environment variable of WMQ. This value, which is present only when the client-based messaging library is used, defines a channel and specifies the location of the WebSphere® MQ server and the communication method that is used.

An application can specify the mqchannelname, mqxpt, and mqconnname attributes of a channel at run time. This enables the client application to connect to multiple server queue managers simultaneously. If these values are present, they take precedence over other values. For more information, see information about using the MQCNO structure on an MQCONNX call in the documentation.

Whenever each service is connected to WMQ, the service uses environment variables in the following order:

MQCNO values
Variables in the service
Variables in the instance
WMQ default values