?Access as DB2 prototyping tool

Article View: comp.databases.ms-access

Article #79

Back to comp.databases.ms-access Previous Next

#79

From: kanaus
Date: Fri, 23 Feb 1996 00:00

18 lines
1564 bytes

We have been using MSAccess (v2) as a development database for a
Visual Basic application targeted for MVS DB2 (using passthrough) and
have found a number of pecularities (e.g. SQL syntax of ORDER BY
different in Jet2.0 and DB2, Jet 2.5 cannot attach DB2 tables).

As Access offer a number of advantages (e.g. easy to move to windows
based laptop for demo, tight integration with VB) I wonder whether
anyone has done up a document that they can share on what are the
differences and how to provide workarounds.

Also interested in views whether there are other good development
databases alternatives (price, compatibility, functionality, ease of
setup), given that we will be using DB2 in production.

Please send a copy of your views to my email address as this is cross
posted to newsgroups that I do not visit frequently.

Thanks in advance for your contributions.

Technical Details

Message-ID: <Dn7v8C.DnK@gil.com.au>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10da59,e11c4457f91ac4a7,start
X-Google-Attributes: gid10da59,public
X-Google-Thread: 1143a7,e11c4457f91ac4a7,start
X-Google-Attributes: gid1143a7,public
X-Google-Thread: ff0ac,e11c4457f91ac4a7,start
X-Google-Attributes: gidff0ac,public
From: kanaus@gil.com.au
Subject: ?Access as DB2 prototyping tool
Date: 1996/02/23
Message-ID: <Dn7v8C.DnK@gil.com.au>
X-Deja-AN: 140659033
x-nntp-posting-host: cs8p7.ipswich.gil.com.au
sender: news@gil.com.au
organization: Global Infolinks Internet Server, Ipswich Qld Australia
newsgroups: comp.databases.ms-access,bit.listserv.db2-l,comp.lang.basic.visual.database