Tables that are mapped to WMQ 3can generate non-database errors if the underlying WMQ request fails. 3In the example below, a VTI mapping was established using a bad service 3definition, and the error was not recognized until a SELECT statement 3was executed against the table.
3 33
3BEGIN WORK; 3EXECUTE FUNCTION MQCreateVtiReceive('vtiTable',"BAD.SERVICE"); 3SELECT * from vtitable; 3 3(MQ015) - FUNCTION:MqiGetServicePolicy, SERVICE:BAD.SERVICE, 3POLICY:IDS.DEFAULT.POLICY :: 3BAD.SERVICE is not present in the database "informix".MQISERVICE table. 3Error in line 1 3Near character position 23Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]