SET TAG

Specify the routing tag that will be used to route subsequent queries in the current session.

When a session routing tag is set, it is used to route queries according to the Workload Management (WLM) routing rules defined for that routing tag. If a ROUTING_TAG connection property is already set for the session, SET TAG will override it. The setting remains active until the session ends or until it is explicitly reset using RESET TAG. Changing the session routing tag does not persist across sessions.

Syntax

SET TAG <tag_name>

Parameters

<tag_name> String

Specifies the routing tag for all subsequent queries in the session. A Workload Management (WLM) routing rule must be defined to route queries using this tag.

Examples

Create a WLM routing rule using tag Dashboard and set session routing tag.

tag() = 'Dashboard'

SET TAG Dashboard;