Example - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

This example is based on the data from the previous example.

Consider a column created with a CHARACTER data type.

CREATE TABLE Test3 (Col3 CHAR(5)); 

The column is loaded by selecting, without a sign FORMAT phrase, values from an “unattached” column, as follows.

INSERT INTO Test3 (Col3) 
SELECT Col2 FROM Test2 ;

The values that are inserted are the following:

Col3  
-----
   
 5678 
-9012

The sign FORMAT phrase must be included in the query specification in order to insert the values ‘5678B’ and ‘9012L’.