Date: Wed, 15 Sep 2010 17:08:05 -0700
Reply-To: CICS List <CICS-L@LISTSERV.UGA.EDU>
Sender: CICS List <CICS-L@LISTSERV.UGA.EDU>
From: Tony Saul <generalemaillists@YAHOO.COM.AU>
Subject: Re: CICS IA and DB2 LOAD Utility
If you don't have any products load utility you could look at using DSNTEP2 or
DSNTEP4 to run INSERTs. I think DSNTEP4 will take multiple row inserts (DB2 V8+)
or the source is provided (in PL/1). If you don't have PL/1 compiler, the source
is reasonably easy to read and base a Cobol program to do the work. Not as easy
as the LOAD utility. You are going to find it hard to live with DB2 if you have
no LOAD utility (fram any vendor) at all.
If you have another vendors Load utility you should be able to use that instead.
From: "Vogtmann, Wallace B" <wvogtman@TCFBANK.COM>
Sent: Wed, 15 September, 2010 11:56:39 PM
Subject: CICS IA and DB2 LOAD Utility
We're attempting to install CICS IA in our environment, utilizing our "metered"
DB2 for z/OS installation.
We do NOT have the DB2 Utilities package and so do not have the LOAD utility,
which CICS IA wants to use.
We've been told by IBM that "There is a possibility that you could write to a
CSV file and then load it into the database."
Anybody doing something similar to this? Any other options available to us?
Alternative DB2 load utility?
- Wally Vogtmann
----------------------------Disclaimer---------------------------- This email
may contain privileged and/or confidential information that is intended solely
for the use of the addressee. If you are not the intended recipient, you are
strictly prohibited from disclosing, copying, distributing or using any of the
information contained in the transmission. If you received this communication in
error, please contact the sender (“Company”) immediately and destroy the
material in its entirety, including all electronic and hard copies. This
communication may contain nonpublic personal information about consumers which
is subject to restrictions under the Gramm-Leach-Bliley Act and the
Sarbanes-Oxley Act. You may not directly or indirectly reuse or disclose such
nonpublic personal information for any purpose other than to provide the
services for which you are receiving the information. There are risks
associated with the use of electronic transmission. The sender of this
information does not control the method of transmittal or any service providers
and the sender assumes no duty, liability, or obligation for the security,
receipt, or any third party interception of this transmission. The Company
reserves the right to amend statements made herein in the event of a mistake.
Unless expressly stated herein to the contrary, only agreements in writing
signed by an authorized officer of the Company may be enforced against it.