COBTEP2

Robert Glover

COBTEP2
We are converting to V9. As part of my research I have found that some folks are using COBTEP2, a "DSNTEP2' look-alike pgm but with modifications. Not sure if we will keep it - depends on the work involved. Source is missing and I do not see it in the archives. Does anyone have a copy they can send me?

Thanks, Bob

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Lizette Koehler

Re: COBTEP2
(in response to Robert Glover)
I have searched the IDUG DB2-L archives and came up with the following


From 2006:
Years ago there was a posting for a cobol version of DSNTEP2 called COBTEP2. It was written by J L Evans. The output of the sql was from 80 to 4096 bytes. You might check the archives or maybe J L is still on the list.


So I wandered over to GSE UK DB2 Working Group (http://www.gseukdb2.org.uk/shareware.htm) And found the following


Darwin This flexible utility is a replacement for DSNTEP2 that does not require PL/1 libraries which can be useful for those sites that do not use PL/1. It is provided in COBOL source form, with sample JCL and usage notes. The original listing for EDBAB017 provided by Justin Abbott was changed on April 3rd 2006 to prevent 00E7000C abends using some suggestions from Carol Sutkin and David Waugh, and again on May 22nd to prevent problems handling SQLCODES of +100 following another suggestion by James Campbell. Justin Abbott
(Barclays)


Darwin2

This is an updated version of DARWIN which has been very kindly sent to us by Gary Joehlin, with the agreement of his employer Sallie mae Inc. Naturally we would like to thank both Gary and Sallie Mae for allowing us all to share in these improvements. The original Darwin code has been updated by Gary to support the following improvements:

1) Corrected DSNTIAR message truncation - When an SQLCODE other than +0 or +100 was encountered, Darwin truncated the output of DSNTIAR which made diagnosing SQLCODEs such as -904 more difficult.
2) Changed support of the size of the SQL statement from 32K to 2Gb - This will require a current COBOL compiler (to support the SQL TYPE IS CLOB) and a DB2 version that supports the 2Gb SQL statement size.
3) Modified the code to support DECIMAL(31) data type - This will require a change in your COBOL Compiler parameter list to include “ARITH(EXTEND)”.
Gary Joehlin
(Sallie Mae Inc.)


Darwin3

This is an updated version of DARWIN2, modified by Graham Clarke from TNT. Graham updated the Darwin code to avoid an occasional AbEnd when the size of variable DATA-REC was too small. Cheers Graham!
Graham Clark
(TNT)


So maybe this is what you are looking for

Lizette



> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Glover
> Sent: Tuesday, January 18, 2011 5:39 PM
> To: [login to unmask email]
> Subject: [DB2-L] COBTEP2
>
> We are converting to V9. As part of my research I have found that some folks are
> using COBTEP2, a "DSNTEP2' look-alike pgm but with modifications. Not sure if we will
> keep it - depends on the work involved. Source is missing and I do not see it in the
> archives. Does anyone have a copy they can send me?
>
> Thanks, Bob
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2 information. *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home
> of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv