Search code examples
db2nvarchar

nvarchar and nclob with db2 9.7

The db2 9.7 sql reference clearly states that nvarchar and nclob datatypes are synonyms of vargraphic and dbclob, respectively (link here)

Yet, when I write a simple create table statement, it doesn't work with nvarchar and nclob - I get an error message about unknown tokens. When using vargraphic and dbclob as is well.

Any idea why?

Solution

  • As stated in the documents, NVARCHAR and NCLOB were introduced in DB2 9.7 with Fixpack 2.

    I presume you're running either the GA release or Fixpack 1.