EXCSQLSET packet

The EXCSQLSET packet is sent by client to start the execution of a SET statement.

This packet may contain a number of parameters, the most common are:

• MONITOR (int): a set of flags specifying whether this command should be monitored. The following flags can be combined: 

  • 0x80000000: return server ETIME (this is the most common)

  • 0x40000000: return statement monitoring identifier

  • 0x20000000: return unit of work sequence

• RTNSETSTT (byte): specifies whether the server should return SQL SET statements for special registers whose setting have been modified on the current connection

• RDBNAM (string): the name of the database

The SQL statement is available as the sql property, and can be changed.

SET statements can be intercepted and modified (or even cancelled) in Set filters.

Example

context.packet.sql = "SET CLIENT WRKSTNNAME 'MachoMan'";

context.packet.MONITOR = 0x80000000;