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.
This topic has been locked.