linking to DB2 tables (timestamp fields).

K

Kirk Daledovich

I'm trying to link to a DB2 UDB (v8.1.3) table that has
the timestamp field as a primary key. Access converts the
timestamp field to date time, which then returns
(#deleted) becasue it shortens the time field down and the
data is no longer unquie. Is their a way to change how
access converts the DB2 timestamp field? To text instead
of date time.

We replicate this DB2 table from our mainframe down to a
NT box. The customer is linking to the tables on the NT
box for security reasons. When I link the same table on
our mainframe which has DB2 (v7) access converts the
timestamp field to text which is what I want it to do from
the replicated server.

Thank for any help or suggests.
Please email or post with any questions
[email protected]
 
Top