[log in to unmask] wrote:
: This relates to ALLBASE/SQL, IMAGE/SQL, MS Access
 
: (3) Is this a MS Access problem, and ODBC problem, or an IMAGE/SQL problem?
: (4) Are there better ways to map dates in IMAGE/SQL stored as X8, or any of
:     a number of other formats that have been dreamed up over the last 20
 
The basic issue with most gateways is that they re-map definitions into
their view of the world. In non-relational systems such as RMS, KSAM,
TurboImage etc the apps created various datatypes and structures which
the RDBMS cannot manage. The ODBC vendors who are trying to provide
a direct solution for some of these systems are able to manage most
if not all of the common types/structures. You probably should have
a look at MB Foster's ODBC solution.
 
--
Nigel Campbell            Voice: (613) 738-1338 ext 3016   P.O. Box 9707,Stn.T
Business Intelligence       FAX: (613) 738-0002            3755 Riverside Dr.
Cognos Incorporated    Internet: [log in to unmask]         Ottawa ON K1G 4K9
                      URL: http://www.cognos.com           CANADA