Client applications can use a VARCHAR to insert a value into an MBB column. The VARCHAR must have the following format:
(xmin, ymin, zmin, xmax, ymax, zmax)
where white space can appear anywhere.
For queries that select data from an MBB column, Teradata Database returns the MBB data as a VARCHAR(340) using the same format (xmin, ymin, xmax, ymax).
Consider the following definition of a table that defines an MBB column.
CREATE TABLE sample_MBBs (skey INTEGER, shape_mbb MBB);
A query that selects data from the shape_mbr column results in Teradata Database returning the column data as a VARCHAR(340):
SELECT * FROM sample_MBBs; SKEY SHAPE_MBB -------- ------------- 1002 (10, 3, 1, 22, 7, 2)