We have an existing application that runs on WebSphere using DB2 UDB v8.0 as the database. The version of DB2 supports BIGINT which is a 64 bit integer, a Java long primitive. All of our entity beans use a long primitive to store a timestamp.
DB2/390 does not have a BIGINT data type. It only has a 32 bit integer. Has anyone tried to map a 64 bit integer in an entity bean to a DB2/390 data type? I'm thinking it's going to be a DECIMAL but I'm not sure. I want to get some opinions before I start experimenting.
answer:Use Decimal(19,0), this was recommended to me by an IBM DB2 AIX to Z/OS migration expert.
reference
No comments:
Post a Comment