Deprecated datatype in database install script for DB2

Question

Deprecated datatype in database install script for DB2

Opened this issue 4 years ago · 1 comments

A part of the db2 database installation script contains this row definition:

   stanza			 LONG VARCHAR    NULL,

This seems to be a copy/paste error. A column can't be both a LONG and a VARCHAR.

This column is supposed to contain text, so a VARCHAR is most appropriate.

Answer 1 · 2020-12-11T11:22:03.000Z

My bad: LONG VARCHAR actually was a valid datatype in DB2, but was deprecated in version 9.7. Let's replace it with a more modern datatype, to prevent future problems.