MQCreateVtiWrite() function
The MQCreateVtiWrite() function creates a write-only VTI table and maps it to a queue that manages.
Syntax
- table_name
- Required parameter. Specifies the name of the table to be created. The queue pointed to by the service_name parameter is mapped to this table.
- service_name
- Optional parameter. Refers to the value in the servicename column of the "informix".mqiservice table. If service_name is not specified, IDS.DEFAULT.SERVICE is used as the service. The maximum size of service_name is 48 bytes.
- policy_name
- Optional parameter. Refers to the value in the policyname column of the "informix".mqipolicy table. If policy_name is not specified, IDS.DEFAULT.POLICY is used as the policy. The maximum size of policy_name is 48 bytes.
- maxMessage
- Optional parameter. Specifies the maximum length of the message
to be sent or received. The default value is
4000; the maximum allowable size is32628. If the value is-1, the message is a CLOB data type. If the value is-2, the message is a BLOB data type.
Usage
You can perform only an insert operation on this table. You cannot perform a select operation on this table.
The
following table describes how the arguments for the MQCreateVtiWrite() function
are interpreted.
| Usage | Argument interpretation |
|---|---|
| MQCreateVtiWrite(arg1) | arg1 = table_name |
| MQCreateVtiWrite(arg1, arg2) | arg1 = table_name arg2 = service_name |
| MQCreateVtiWrite(arg1, arg2, arg3) | arg1 = table_name arg2 = service_name arg3 = policy_name |
| MQCreateVtiWrite(arg1, arg2, arg3, arg4) | arg1 = table_name arg2 = service_name arg3 = policy_name arg4 = maxMessage |
Example
The following example creates a
table named
qm0vti for service lser.qm1. execute function MQCreateVtiRead("qm0vti", "lser.qm1");