Bytes (Teradata Database) - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

This function is only available when connected to a Teradata database.

The non-standard Bytes function is supported for determining the length of variable byte data. When used with fixed length byte data, the defined column length is always returned. When dragging a Bytes operator into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Other > Bytes

A byte column and/or expression for which to get the length can be moved into the (empty) branch of the tree.

When used in conjunction with the Trim function, the Bytes function can also be used to determine the length of fixed length byte data by first trimming null-byte characters, as shown below.

Variable Creation > Input > Variables: SQL Elements pane - Other > Bytes > Trim