Table creation/Postal addresses: Difference between revisions

db2 => DESCRIBE TABLE Address;

Data type Column

Column name schema Data type name Length Scale Nulls

------------------------------- --------- ------------------- ---------- ----- ------

ADDRID SYSIBM INTEGER 4 0 No

ADDRSTREET SYSIBM VARCHAR 50 0 No

ADDRCITY SYSIBM VARCHAR 25 0 No

ADDRSTATE SYSIBM CHARACTER 2 0 No

ADDRZIP SYSIBM CHARACTER 10 0 No

5 record(s) selected.