🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.basic.visual.database
Article #7

Re: Vis Basic to MVS DB2

#7
From: Vadim Rapp
Date: Wed, 22 May 1996 00:00
28 lines
2169 bytes
Gary Long <garyl@magna.com> wrote:
>>
>>We are converting our existing COBOL/DB2/CICS apps to a Visual Basic
>>front-end (running on Win/NT or Win 3.11) but the data will remain in
>>DB2 on MVS.  
>
>Dave, it depends a lot on the type of application you are creating.  If it is 
>retrieval-intensive -- DSS or whatever -- then a DBMS gateway such as DDCS is 
>the right choice.  If it is transaction-oriented, then I highly recommend 
>IBM's CICS External Client Interface (ECI).
>For transacations, ECI is easy and clean.  Works like a charm.
>Only problem with the ECI is that it is C-oriented making it a little hard
>to use from PB or VB.  For our Application Generator we wrote a DLL to make 
>it easy (not a real big deal).

I wouldn't recommend from the very beginning to create smth aside of standards, write 
proprietary DLL which in the future definitely face some incompatibility problems with newer 
releases and thus restrict some newer features. There's ODBC standard, there's DRDA standard, 
why not use? Why become dependable of CICS logic? The advantage of ODBC-oriented approach is 
that your environment stays open, and it's not a problem in the future to add some new 
ODBC-compliant data source. There are lots of ODBC-compliant tools, I am not that sure about 
CICS-compliant ones.

6 months ago I've commited the project written just in VB with remote DB2. The main manual I 
used was ODBC reference, not even DB2 one!

Vadim
Technical Details
Message-ID: <4nvagk$ghn@news.fnbc.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <3198C3F3.7464@magna.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10da59,9dde9dfc86bf03ae
X-Google-Attributes: gid10da59,public
X-Google-Thread: 10f47b,9dde9dfc86bf03ae
X-Google-Attributes: gid10f47b,public
X-Google-Thread: 1143a7,fcdafbdb4da43481
X-Google-Attributes: gid1143a7,public
From: vrapp@cmg.fcnbd.com (Vadim Rapp)
Subject: Re: Vis Basic to MVS DB2
Date: 1996/05/22
Message-ID: <4nvagk$ghn@news.fnbc.com>
X-Deja-AN: 156161336
references: <3198C3F3.7464@magna.com>
content-type: text/plain; charset=US-ASCII
organization: First Chicago NBD Corporation, Chicago IL, USA
mime-version: 1.0
newsgroups: comp.lang.basic.visual.database,bit.listserv.db2-l,comp.databases.ibm-db2