- TargetColumn
- Specify the name of the input column that contains the packed data.
- OutputColumns
- Specify the names to give to the output columns, one for each virtual column in the packed data, in the order in which the virtual columns appear in target_column.
- OutputDataTypes
- Specify the datatypes of the unpacked output columns. Each datatype must be an MLE data type; for information about these, see Teradata Vantage™ User Guide, B700-4002.
If OutputDataTypes specifies only one value and OutputColumns specifies multiple columns, the specified value applies to every output_column.
If OutputDataTypes specifies multiple values, it must specify a value for each output_column. The nth datatype corresponds to the nth output_column.
- Delimiter
- [Optional] Specify the delimiter (a string) that separates the virtual columns in the packed data. If delimiter contains a character that is a symbol in a regular expression—such as an asterisk (*) or pipe character (|)—precede it with two escape characters. For example, if the delimiter is the pipe character, specify '\\|'. Do not specify both this syntax element and the ColumnLength syntax element. If the virtual columns are separated by a delimiter, specify the delimiter with this syntax element; otherwise, specify the ColumnLength syntax element.
- ColumnLength
- [Optional] Specify the lengths of the virtual columns; therefore, to use this syntax element, you must know the length of each virtual column.
If ColumnLength specifies only one value and OutputColumns specifies multiple columns, the specified value applies to every output_column.
If ColumnLength specifies multiple values, it must specify a value for each output_column. The nth datatype corresponds to the nth output_column. However, the last output_column can be an asterisk (*), which represents a single virtual column that contains the remaining data. For example, if the first three virtual columns have the lengths 2, 1, and 3, and all remaining data belongs to the fourth virtual column, you can specify ColumnLength (2, 1, 3, *).
Do not specify both this syntax element and the Delimiter syntax element. - Regex
- [Optional] Specify a regular expression that describes a row of packed data, enabling the function to find the data values.
- RegexSet
- [Optional] Specify the ordinal number of the data group in regular_expression that represents the data value in a virtual column.
- IgnoreInvalid
- [Optional] Specify whether the function ignores rows that contain invalid data.
- Accumulate
- [Optional] Specify the names of the InputTable columns to copy to the output table.