Using SQL syntax to override DB2 automatic column name generator on iSeries

(Kent Milligan) In production, we never drop and recreate tables. In test we do. Recently, we used the ALTER statement to remove a column in the table. The column removed seemed to have the internal name of MAX_P00001. In the production table there is still a MAX_P00002 and a MAX_P00003. In test tab

Read More - Register for Free Membership