OffsetPosition - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
pxm1544831938750.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

The OffsetPosition parcel requests that the Teradata SQL response returning a single Large-object selected by a Locator be repositioned to a specified BLOB byte offset or CLOB character offset.

Usage Notes

OffsetPosition is included in a Continue request to reposition to a particular byte in a Largeobject.

If present, the OffsetPosition parcel must immediately precede either the ExtendedKeepRespond or KeepRespond parcel.

Parcel Data

Field information for the OffsetPosition parcel is as follows:

Parcel Flavor Parcel Body Length Parcel Body Fields
159 12 Statement Number : 2 bytes

Unused : 2 bytes

Offset : 8 bytes