Shareware

[ Home ] [ What's New ] [ Meetings ] [ Tech Info ] [ SDUG ] [ Shareware ] [ Committee ] [ GSE Info ] [ Feedback ]

This page contains links to any programs, utilities, sample SQL and other miscellanous odds and ends which have been provided by our members for public use.

All items are distributed on an as is basis, and absolutely no warranty is expressed or implied

Item	Description	Submitted By
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)
Darwin4	This is an updated version of DARWIN3, modified by Gary Joelin from Sallie Mae Inc. It caters for a redefinition of the syntax rules of embedding certain special registers within a scalar function. He's also made various other code improvements, all of which are documented in the code. Good man, Gary.	Gary Joehlin (Sallie Mae Inc.)
DB2CPI	DB2CPI is no longer freeware but is still available for download and evaluation. For further interest please contact Higobi Systems Ltd at info@higobi.com. The User Group Committee would like to thank Glen for allowing us to share this Software for the past 3 years.