Rosetta Code

Table creation/Postal addresses: Difference between revisions

Page Discussion

Table creation/Postal addresses (view source)

Revision as of 22:09, 25 April 2018

98 bytes added ,  6 years ago
→‎{{header|SQL PL}}
Line 1,208:
Output:
<pre>
db2 -t
db2 => CREATE TABLE Address (
db2 (cont.) => addrID INTEGER generated BY DEFAULT AS IDENTITY,
addrStreet VARCHAR(50) NOT NULL,
db2 (cont.) => addrCity addrStreet VARCHAR(2550) NOT NULL,
db2 (cont.) => addrState CHAR(2)addrCity VARCHAR(25) NOT NULL,
db2 (cont.) => addrZIP addrState CHAR(102) NOT NULL,
db2 (cont.) => addrZIP CHAR(10) NOT NULL
);
db2 (cont.) =>);
DB20000I The SQL command completed successfully.
</pre>
Anonymous user
Retrieved from "https://rosettacode.org/wiki/Special:MobileDiff/11579"