General discussion

Locked

UDB DB2 and Access

By brett_phipps ·
At my shop we use Access to manually view and edit our DB2 database. We have been having problems, though, due to the fact that Access does not handle date and timestamps in the same manner. I'm ready to scrap Access in favor of a different product if I can find a good simple one to use (preferably freeware or shareware that is specifically designed to interact with DB2 db's). Are there any suggestions. If anyone is curious about the problems I'm having I can go into more detail.

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

UDB DB2 and Access

by NetMan_OVO In reply to UDB DB2 and Access

Try using StartOffice 5.2 it is a freeware & can be downloaded from http://www.sun.com

Hope this helps you :-)

Collapse -

UDB DB2 and Access

by brett_phipps In reply to UDB DB2 and Access

I attempted this, but this program is not really free. Yes you can get it for free, but the installation issues required to get it to run will require at least 2 days of my valuable time reading through the forums and making multiple attempts to get it correct. This program checks user issues and the like which caused me to be able to see that the DB2 table existed but it wouldn't let me read the values in the table because of access issues. When I called Tech support they wanted to charge $25 per incident to provide any support. The product is so new that there is little in the way of useful forums and is clogged with some jerks advertisements for some stupid website.

Collapse -

UDB DB2 and Access

by joekendall99 In reply to UDB DB2 and Access

Can you please give more detail? How does DB2 handle dates and timestamps differently than Access?

Collapse -

UDB DB2 and Access

by brett_phipps In reply to UDB DB2 and Access

The problem is caused by Microsoft Access not DB2. Access is incorrectly reading in a date column through ODBC and then mapping that column to a timestamp.

Access handles dates in a much less robust manner for instance low date in db2 is 0001/01/01 in Access it is 1901/01/01. A timestamp in DB2 takes the form of 2000-01-20-09.40.52.994174 I believe Access interprets this as a text field.

Collapse -

UDB DB2 and Access

by phil In reply to UDB DB2 and Access

You can circumvention this problem by one of the Patch settings in the Db2 Client Config (not sure which - have a hunt through and you'll find it).
For an alternate tool look at Advanced Query Tool at www.querytool.com. This is designed to work with DB2 (and other databases), and is way better than Access. It has a setting to avoid the timestamp problem. It installs easily (5 minutes). While it is not free ($50) you get an unlimited trial period during which 90% of the function is available.

Collapse -

UDB DB2 and Access

by brett_phipps In reply to UDB DB2 and Access

I almost jumped up and down when I saw cool and easy Advanced Query Tool was. I want it, I'm going to beg the office to purchase it. Thanks!

Collapse -

UDB DB2 and Access

by RRV In reply to UDB DB2 and Access

if it is DB2/400 u might be using a middleware like CA/400 express. most of these have inbuilt utilities to export/import data to access or any MS office database. but the best solution i can give is do'nt use date and time as it is in access or in DB2. use it as yyyymmdd format long integer so that manipulation, validation etc are very easy and database does'nt depend on system date or time. and this technology works very fine in all the databases which i have created and worked in my experience.
All the best

Collapse -

UDB DB2 and Access

by brett_phipps In reply to UDB DB2 and Access

While I agree that changing the layout of the database would solve the problem, I can't change the database. The database is locked down in it's design. I create the database using Cool:Gen from a subset of the database from the Central Encyclopedia on the mainframe. I then build the database on my PC and populate it with data so that the developers can do coding and testing on their PC's. If I change the layout of the database Cool:Gen won't be able to use the database.

Collapse -

UDB DB2 and Access

by brett_phipps In reply to UDB DB2 and Access

This question was closed by the author

Back to Web Development Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums