Article View: comp.lang.basic.visual.database
Article #4Re: Vis Basic to MVS DB2
From: Gene Kligerman
Date: Tue, 21 May 1996 00:00
Date: Tue, 21 May 1996 00:00
25 lines
1682 bytes
1682 bytes
Michael Prowell wrote: > > We are currently using DDCS. As you said, retrieval works well and is > fairly quick. Updating, on the other hand, with any volume, stinks. > > We are in the process of creating stored procedures on the mainframe > to handle all updates. Plan is to batch all updates and let the > stored procedure parse and apply. > > Anyone have any real life experience with this type of approach? Have you considered using the "Compound SQL" feature supported by DDCS? It allows you to batch a number of insert/update/delete/... SQL statements in a single DRDA request that flows over the wire. -- Gene Kligerman DB2 Development, IBM Software Solutions Toronto Lab genie@vnet.ibm.com Got a question? The DB2 Product and Service Technical Library might have an answer. Search http://www.software.ibm.com/data/db2/support/servinfo
Technical Details
Message-ID:
<31A24097.446B@vnet.ibm.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3198C3F3.7464@magna.com> <4njot8$3dv@star.epix.net>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: Gene Kligerman <genie@vnet.ibm.com> Subject: Re: Vis Basic to MVS DB2 Date: 1996/05/21 Message-ID: <31A24097.446B@vnet.ibm.com> X-Deja-AN: 155996712 sender: usenet@eclipse.torolab.ibm.com (eclipse sysadm) references: <3198C3F3.7464@magna.com> <4njot8$3dv@star.epix.net> content-type: text/plain; charset=us-ascii organization: IBM Software Solutions Lab mime-version: 1.0 newsgroups: comp.lang.basic.visual.database,bit.listserv.db2-l,comp.databases.ibm-db2 x-mailer: Mozilla 2.01 (X11; I; AIX 2)