Populating Destination in the local environment tree

Use the Destination subtree to set up the target destinations that are used by output nodes, the HTTPRequest node, the SOAPRequest node, the SOAPAsyncRequest node, and the RouteToLabel node.

Adding a queue name for the MQOutput node with the Destination Mode property set to Destination List

SET OutputLocalEnvironment.Destination.MQ.DestinationData[1].queueName = newQueue;

Changing the default URL for a SOAPRequest node or a SOAPAsyncRequest node request

SET OutputLocalEnvironment.Destination.SOAP.Request.Transport.HTTP.WebServiceURL = newUrl;


Changing the default URL for an HTTPRequest node request

 SET OutputLocalEnvironment.Destination.HTTP.RequestURL = newUrl;

Adding a label for the RouteToLabel node

SET OutputLocalEnvironment.Destination.RouterList.DestinationData."label" = newLabel;


N.B. newUrl can be a user defined property.

Extract from IBM Information Center

ESQL Functions

UUIDASCHAR
A function that returns a universally unique identifiers (UUID) as a CHARACTER value.

DECLARE uuid CHAR;

SET uuid =  UUIDASCHAR(source_blob_uuid);
SET uuid =  UUIDASCHAR;

If (source_blob_uuid) is not specified, UUIDASCHAR creates a UUID and returns it as a CHARACTER value. ed.
If (source_blob_uuid) is specified, UUIDASCHAR converts an existing BLOB UUID to the character form.

The result is NULL if a NULL parameter is supplied.