Share via

2.2.7.16 OFFSET

  • Article

Token Stream Name: 

 OFFSET

Token Stream Function:

Used to inform the client where in the client's SQL text buffer a particular keyword occurs.

Token Stream Comments:

  • The token value is 0x78.

  • The token was removed in TDS 7.2.

Token Stream-Specific Rules: 

 TokenType        =   BYTE
 Identifier       =   USHORT
 OffSetLen        =   USHORT

Token Stream Definition: 

 OFFSET           =   TokenType          ; (removed in TDS 7.2)
                      Identifier
                      OffSetLen

Token Stream Parameter Details

 Parameter

 Description

TokenType

OFFSET_TOKEN

Identifier

The keyword to which OffSetLen refers.

OffsetLen

The offset in the SQL text buffer received by the server of the identifier. The SQL text buffer begins with an OffSetLen value of 0 (MOD 64 kilobytes if value of OffSet is larger than 64 kilobytes).