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 to insert the values ‘5678B’ and ‘9012L’.