17.10 - Transferring Data using the Dynamic Schema Feature with GetBuffer and PutBuffer Functions - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Release Date
June 2021
Content Type
Programming Reference
Publication ID
B035-2516-061K
Language
English (United States)

To implement the Export driver’s dynamic schema feature while using GetBuffer and PutBuffer to transfer data, follow these steps:

  1. Create an Export driver and enable the GetBuffer feature by setting the TD_BUFFER_MODE attribute to Yes (Y).
  2. Create a Load, Update, or Stream driver and enable the PutBuffer feature by setting the TD_BUFFER_MODE to Yes (Y).
  3. Initiate the Export driver.
  4. Initiate the Load, Update, or Stream driver.
  5. Use the GetEvent function to query the TD_Evt_BufferLayout event for the Load, Update, or Stream driver.
  6. Use the PutEvent function to pass the event data returned by the Load, Update, or Stream driver’s TD_Evt_BufferLayout event directly into the Export driver’s TD_Evt_BufferLayout modifier.

At this point, data can be retrieved from the Export driver using the GetBuffer function and loaded directly using the Load, Update, or Stream driver’s PutBuffer function.

The buffer layout values for the Load, Update, or Stream drivers change depending on the user environment and may be defined differently in future releases. Always obtain these values from the event method when transferring data between the Export driver’s GetBuffer function and the Load, Update, and Stream drivers’ PutBuffer function.