Documentation about CREATE TABLE claims that "TIMESTAMP WITH TIME ZONE" can be used as a type for table column. But when I try to create a table with such type I'm getting the following error:
db2 => create table test (n int, t timestamp with time zone, c varchar(24));
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "time" was found following "nt, t timestamp
with". Expected tokens may include: "REFERENCES". SQLSTATE=42601
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "time" was found following "nt, t timestamp
with". Expected tokens may include: "REFERENCES". SQLSTATE=42601
I'm using Command Line Processor for DB2 Client 11.5.8.0
What I'm doing wrong?
Best regards,
Michael
