Topic
No replies
SystemAdmin
SystemAdmin
90 Posts
ACCEPTED ANSWER

Pinned topic ODS bug when trying to create a view that formats a timestamp

‏2011-10-24T21:03:09Z |
ODS has a bug in that it prevents the creation of a DB2 view that converts a timestamp column to a CHAR(TIME(timestamp),USA).

If you have a table MYTABLE with a timestamp column named MYTIMESTAMP, then we should be able to create a view named MYVIEW that has the following SQL:

SELECT CHAR(TIME(MYTIMESTAMP),USA) FROM MYTABLE

When we attemp to create this, the update validation from ODS fails.

We are able to manually create the DB2 view using the DB2 control center, but this defeats the value of ODS.