Hi all Experts!

We are creating a replication between ERP LN tables and a System Legacy's tables..

Both are on the same database on IBM DB2

We got an issue that one of the fields present on the legacy's table is of data type "Time". That means, on the hour on format hh:mm:ss

The only way I found to create something near to this, was creating a new domain of type utc/date without format to the Date(dd/mm/yyyy). Only wich the format of the hour.

On the application works fine. The field displayed have just the hour.

But on the database it still a Timestamp. DD/MM/YYYY hh:mm:ss.

As you may know the replication just works if both tables have exactly the same definition.

Thanks in advance!!

Did u try using the domain tiasc.time? or you can create an equivalent of it.

Thx

Did u try using the domain tiasc.time? or you can create an equivalent of it.

Thx

Thnx man,

but this domain is of data type Long(on DB2 an integer).
The format field is only applicable on the runtime data dictionary.

Accessing directly on the database the format will not appear.