Java Constant/Variable Mode Table Function | UFC Code Examples | Vantage - Java Constant/Variable Mode Table Function - Advanced SQL Engine - Teradata Database

This example shows the Java code for a table function that supports both Tbl.TBL_MODE_CONST and the Tbl.TBL_MODE_VARY modes. The Tbl.TBL_MODE_CONST is very simple in that any one AMP will extract the data out of the text string that is passed in.

This example extracts some data out of a 'raw' text field to generate a bunch of rows. The raw data is supposed to be of the form of numbers as follows:

<store number>,<entries>:<customer ID>,<item ID>, ...; repeat;