SQL Limits for DB2 V8 column names.

Document ID : KB000054542
Last Modified Date : 14/02/2018
Show Technical Document Details


When altering a column in RC/Update to increase the length of the column name to more than 30 bytes, it does not allow input past 30 bytes


In DB2 V8, the SQL limit for the name of a column is 30 bytes. Limits on other items have also been increased. The SQL limits can be found in the IBM documentation DB2 UDB for z/OS Reference (SC18-7426-05), Appendix A.