FORMAT= determines how character and numeric values in a column are displayed by the query-expression. If the FORMAT= modifier is used in the ALTER, CREATE TABLE, or CREATE VIEW statements, it ...

Any column that is not modified retains its original values, except in certain queries using the CASE expression. See CASE expression for a description of CASE expressions. To add, drop, or modify a ...