OffsetPosition - Teradata Director Program

Teradata Director Program Reference

Product
Teradata Director Program
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
hwt1488824663348.ditamap
dita:ditavalPath
Audience_PDF_include.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:

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

Unused : 2 bytes

Offset : 8 bytes