TD_DataType - Parallel Transporter

• PERIOD(DATE)
• PERIOD(TIME(n))
• PERIOD(TIME(n) WITH TIME ZONE)
• PERIOD(TIMESTAMP(n))
• PERIOD(TIMESTAMP(n) WITH TIME ZONE)

  The (n) corresponds to the precision of the column. The precision of these columns can be an integer from zero to six. Six is the default if no precision is specified. The PERIOD(DATE) data type has no precision.

• NUMBER
• NUMBER(*)
• NUMBER(*scale)
• NUMBER(precision)
• NUMBER(precision,scale)

The NUMBER data type is a variable length numeric column with the following external specification:

<1-byte Length><2-bytes Scale><1 to 17 bytes 2's complement representation of the unscaled value in the client-appropriate endianness>

• User applications should add the length of the NUMBER type as '18' bytes (recommended) while defining the schema. For example:

  schema -> AddColumn("Number_dt", TD_NUMBER, 18, 5, 2); Length = 18, Precision = 5, Scale = 2.

• For the Number(*) type, a precision of -128 should be added to the schema

  Number(*, 4) is represented as schema -> AddColumn("Number_dt", TD_NUMBER, 18, -128, 4); Length = 18, Precision = -128, Scale = 4

  If NUMBER is...	Precision Passed to Operator is...	Scale Passed to Operator is...
  NUMBER	-128	-128
  NUMBER(*)	-128	-128
  NUMBER(*,scale)	-128	scale
  NUMBER(precision)	precision	0
  NUMBER(precision,scale	precision	scale

• Create ARRAY data type as follows:

  CREATE TYPE pnum AS CHAR(10) ARRAY[2];

• Create target table as follows:

  Create table emp(Associate_Id integer, phone_nums pnum);

• Add the column to the schema in Teradata PT API application:

  schema -> AddColumn("phone_nums", TD_VARCHAR, 47);

INSERT INTO target_table ( :Associate_Id, :phone_nums );

• inline JSON
• deferred JSON.

• inline LOB
• deferred LOB

• The XML data types are supported with UPDATE and STREAM operators only.
• There are two type of XML data types (Large Object data types), inline XML and deferred XML.
• When an inline XML data type is specified, its column data is stored in the data rows defined by the schema just in the same way the data is stored for non-XML columns. The maximum size supported for an inline XML is 64,000 bytes.
• When a deferred XML data type is specified, its column data is contained in files rather than in the data rows defined by a Teradata PT API schema. The maximum size supported for deferred XML is 2,000,000,000 bytes.
• The names of the files that contain deferred XML data are stored in data rows exactly like VARCHAR column values,with a 2-byte length prefix. The row value is either a fully qualified path name or the name of a file that Teradata PT API looks for in the directory out of which it executes. The data type TD_XML_AS_DEFERRED_BY_NAME indicates that XML file identifiers are expected in the data stream instead of the XML data itself.