Consultant Packages
for ETI*EXTRACT Release


This page is a generated page; the Consultant Package sourcebase ship list is called to generate this page.

Last Generated: Tue Sep 16 16:33:04 CDT 2003


Interim Maintenance Consultant Packages: (Most Recent):
sapr3_IM Interim Maintenance Consultant Package (V01) for SAP/R3 2.10 Template libraries auto-attach on installation.  
mdx_IM Interim Maintenance Consultant Package (V02) for MDX 2.0.3. Template libraries auto-attach on instalation; Manual change required to template definition required after installtion  
cteradata_IM Interim Maintenance Consultant Package (V02) for C/Teradata 1.06. This package is required for support of Teradata V2R4 and V2R5. Also includes the multiload performance improvement package which improves the multiload insert performance by having a NULLIF occur in the Values section of the insert instead of in the field declaration.  
csybase_IM Interim Maintenance Consultant Package (V04) for C/Sybase 1.2.4. Template Libraries auto-attach on installation of this IM package. Manual Grammar changes required after installation.  
csqlsvr_41_IM Interim Maintenance Consultant Package (V07) for csqlsvr_410.  
coboltd_IM Interim Maintenance Consultant Package (V03) for COBOL/Teradata 3.0.1. Auto-attaches template overrides on installation. Manual change to DAS required.  
cobolfs_da_IM  
coboldb2_da_IM  
CP_tcl_fcns_42_IM_V00 Consultant Package for EXT-UNIX-4-2-1-2-TCL-FCNS  
CP_sqltd_410p2_IM_V00 Interim Maintenance Consultant Package (V00) for sqlteradata_410.  
CP_shared_objects_422_IM_V01 Consultant Package for EXT-UNIX-4-2-2-4-L-SHARED-OBJECTS  
CP_sapr3_201p3_IM_V01 Interim Maintenance Consultant Package (V01) for sapr3_201p3.  
CP_sapbw_101_IM_V00 Interim Maintenance Consultant Package (V00) for sapbw_101.  
CP_metascheduler_IM_V00 Interim Maintenance Consultant Package (V00) for Metascheduler.  
CP_cstatic_411_IM_V01 Consultant Package to be used with all DA 4.1 / 4.1.1 C-based DSLs.  
CP_cora_parallel_411_IM_V00 Consultant Package for cora_parallel_41  
CP_cinformix_113p1_IM_V00 Consultant Package for C/Informix 1.1.3 Patch 1.  
CP_cia_102_IM_V00  
CP_cfs_115_IM_V02 Interim Maintenance Consultant Package (V02) for cfs  
CP_cdb2_410p1_IM_V02 Interim Maintenance Consultant Package (V02) for cdb2_410p1. This Interim Maintenance package should be loaded on top of the cdb2 4.1.0 Patch 01.  
CP_cbmqs_jcl_410_IM_V00 Consultant Package for jcl_410.  
CP_cblia_410_IM_V03 Consultant Package for CBLIA_410.  
CP_cblfs_420_IM_V01 This package contains a Consultant Package for cblfs_410. This package must be installed on top of the current patch.  
CP_cbl74ia_101_IM_V00  
CP_cbims_216p1_IM_V01 Interim Maintenance Consultant Package (V01) for cobolims216 patch 1  
CP_cbidms_11_IM_V00 Interim Maintenance Consultant Package (V00) for cobolidms_11.  
CP_cbdb2_410p1_IM_V04 Consultant Package for coboldb2_410.  
CP_adabas_114_IM_V01 Consultant Package for adabas_114.  
Interim Maintenance Consultant Packages: :
CP_tcl_fcns_41_IM_V01 Consultant Package for TCL_FCNS 4.1  
CP_cora_411_IM_V08 Consultant Package for cora_411.  
CP_cora_410_IM_V03 Consultant Package for cora_410.  
CP_cbmqs_410_IM_V01 Consultant Package for cobolmqs_da.  
CP_cblfs_410p1_IM_V05 This package contains a Consultant Package for cblfs_410. This package must be installed on top of the current patch.  
CP_cblfs_225p1_IM_V02 Interim Maintenance Consultant Package (V02) for cblfs225.  

JCL:
CP_jcl This CP contains JCL templates which support compile, link, and execution of COBOL based programs on the MVS machine.  
CP_jcl_42_changeman This package provides changeman support. Additional customization will be required. This package has had no testing, but is intended to give a start for changeman support. Support for COBOL/FS, COBOL/DB2 and MQ/SERIES has been included. Additional changes will need to me made for the MSGPROG.  
CP_jcl_cblfs_sort_b4_qry Sorts an incoming flat file before the query process starts.  
CP_jcl_cblfs_split_pop Splits the output from the populate program into separate files.  
CP_jcl_sqlteradata_42 Consultant Package supporting JCL for sqlteradata for the 4.2 release.  
COBOL/FS:
CP_cblfs222_delimited_read The ability to read cobol source variable length delimited records using unix cobol and unix shell scripts.  
CP_cblfs22_LoadOracle Load Oracle (Oracle Loader) using COBOL/FS single step.  
CP_cblfs_22_tandem This package is a start for Tandem and is based on the Cobolfs 2.2.3 DSL  
CP_cblfs_400_nt_bat Package: CP_cblfs_400_nt_bat Template Definitions to create batch files to run COBOL/FS on NT and template changes to allow the cobol program to compile using Visual Age COBOL.  
CP_cblfs_410p1_db2_lookup Package: CP_cblfs_410p1_db2_lookup Template Libraries to incorporate a DB2 table lookup into a Cobol/FS Program on the query side. This code has not been tested on the Populate side, although it should work.  
CP_cblfs_421_cbdb2_421_lkup This package implements a COBOL/DB2 lookup within a COBOL/FS query or populate program.  
CP_cblfs_421_xml_write Consultant Package to support writing an XML file.  
CP_cblfs_hash_totals The hash totals process wil generate an aggregate total by part.  
CP_cblfs_html The HTML perl script package is used to frame a selected cobol program within an internet browser, so a person is able to easily navigate within the selected program.  
CP_cblfs_multiCopybook The Multi Copybook package is used to clean, flatten and builds the schema properties file for IMS Dump/IMS segment copybooks using the multi_copybook_build.pl Perl script.  
CP_cblmqs_420_Install Consultant Package for cobolmqs_da 4.2.x . This package is used to simplify the ETI*Accelerator for COBOL/MQSeries installation procedure.  
COBOL/DB2:
CP_cbdb2_12_rdb This package is a start for RDB support on VMS and is based on the DB2 1.2 DSL  
CP_cbdb2_410p1_bat Package: CP_cbdb2_410p1_bat Template and Template Libraries to generate bat files for Cobol/DB2. This package uses Template Libraries from Cobol/FS 4.2, so it must be installed prior to this package being installed.  
CP_cbdb2_410p1_uow Package: CP_cbdb2_410p1_uow The templates libraries, grammar and sample global data included in this package will allow the code to commit and rollback unit of work. It tests SQL Codes for specific actions.  
CP_cbdb2_as400 This package contains all the necessary Template Libraries, Template Modules, and Template Definitions to modify the CobolDB2 DA so that Extract may generate programs and cl scripts ready for an AS400 environment.  
CP_cbdb2_audit_trail The audit trail package is used to capture log information in a DB2/UDB table before and after each execution step.  
CP_cbdb2_checkpoint This package contains all the necessary Template Libraries, Template Modules, and Codeblocks needed to implement Checkpoint processing in a cobol/db2 or a cobol/fs program.  
CP_cbdb2_connect_file The db2 connect file package is used to generate a flat file containing all the information needed for an ETI COBOL/DB2 program to access a DB2 database.  
CP_cbdb2_select_lkup The db2 select lookup package is used to change the approach for lookup from CURSOR/FETCH to a SELECT query.  
CP_cbdb2_table_lookup Ability to perform a table lookup on the source side at the database level.  
SAPR3/IDOC:
CP_sapr3_201_performance  
CP_sapr3_report Prints a report to list the German db/unit/part names and their English descriptions for a source database.  
COBOL/IMS:
CP_cbims21_VP_ModVal This package contains the following enhancements: o The capability to insert virtual parts to a conversion source database. o The capability to use a source part modify-value filter.  
CP_cbims_hash_totals The hash totals process wil generate an aggregate total by part.  
C/FS:
CP_cfs111_AggPrec Contains enhancements for the following: o Target side aggregation o Source part precedence control o Source side data cleansing o Target side extended modify value filters o Extended date routines  
CP_cfs112_Prec  
CP_cfs115_ebcdic_to_ascii Package: CP_cfs115_ebcdic_to_ascii Template Libraries to convert an ebcdic file to ascii on unix and also Cobol binary data.  
CP_cfs_115_write_xml Consultant Package (V01) for cfs  
CP_cfs_43_xml_write Consultant Package to support writing an XML file.  
CP_cfs_6312_GramSetDef This package contains modifications to grammars and grammar extension modules to fix the problem documented in PDPR 6312. This FIX applies to CFS 1.1.  
CP_cfs_FilePathEnvVar Use environmental variables for file paths within the CFS query pgm.  
CP_cfs_decimals This package contains a new retrieve schema script (cfs_make_slots) and a cfs_virtual_sp grammar to enable decimals in CFS although there may be loss of precision. This Consultant Package applies for CFS 1.1.  
CP_cfs_pop_lkup Extract 3.3 ONLY Allows the user to perform an in memory lookup in the populate program.  
CP_cfs_repeat_parts Extract 3.3 ONLY This package contains template function changes that allow you to use repeating parts in a cfs ddf.  
CP_cfs_scripts Package: CP_cfs_scripts Perl scripts to convert a COBOL Copybook to either a c struct or a DDF.  
C/ORACLE:
CP_cora_400_iso_date This package adds a target part transformation filter to the DSL for C/ORACLE DA that accepts year, month, and day as 3 separate components (either all strings or all integers) plus a century break year, and produces an ISO standard format date, which is necessary to map to an ORACLE date.  
CP_cora_400_nt_bat Template Definitions to create batch files to run C/Oracle on NT.  
CP_cora_400_sh_js Jobstream for Oracle shell scripts for Coracle_da  
CP_cora_NT Package: CP_cora_NT Template Definitions to create batch files to run C/Oracle on NT and template changes to allow the proc program to compile.  
CP_cora_csh_metascheduler Extract 3.3 and Higher ONLY. Splits the compile and execute into separate scripts.  
CP_cora_dec_vax_dcl  
CP_cora_ksh Provides korn shell scripts for oracle populate.  
CP_cora_replace_select Replace the select statement with your own select statement.  
CP_cora_tbllkup_reject Adds the ability to write or not write a unit based upon a successful or failed table lookup. DO NOT use this package in conjunction with CP_cora12_RejectSupport. There are changes in common libraries that are not merged together.  
CP_coramqs_421_Install Consultant Package for coracle_da 4.2.1 . This package is used to simplify the ETI*Accelerator for C/MQSeries installation procedure.  
C/DB2:
CP_cdb2mqs_421_Install Consultant Package for cdb2_da 4.2.1 . This package is used to simplify the ETI*Accelerator for C/MQSeries installation procedure.  
C/Sybase:
CP_csyb120_tgt_substr This package allow string-delimited substringing.  
CP_csyb120p3 This package enhances support provided by the DSL for C/SYBASE to allow setting prog_type to bulk_load such that a flat file is generated for bulk population of the target database. This package enhances support provided by the DSL for C/SYBASE for generating programs that exercise: 1) programmatic BCP a) multiple target tables b) unmapped parts 2) sql_commit_limit 3) keys containing apostrophes  
CP_csyb12_SrcCstmJoin Allow customization of relation joins. eg. specify "outer" join.  
CP_csyb12_SrcDbAggr This package contains a set of grammars and a template that will allow the Conversion Specialist to specify a various sql functions (SUM, COUNT, etc.). The filter is placed at the source database level.  
CP_csyb_NT_MakeFile C/Sybase Make File package for Query and Populate.  
C/SQLserver:
CP_csqlsvr_410_big_int Consultant Package for csqlsvr_410; provide BIGINT support in retrieve schema. This functionality is included in the interim maintenance (IM) package V07; only load this package if you have IM V06 loaded and do not wish to load IM V07 but need bigint support  
SQL/Teradata:
CP_sqltd_410_enhancements Package: CP_sqltd_410_enhancements Enhancements for the ETI*Accelerator for SQL/Teradata DA V4.1.0. * Explicit support for an SQL CASE Statement (as opposed to nested CASE statements created by an if-then-elseif-elseif-else) * A shell script with the BTEQ query script inline, so you don't have to call the BTEQ utility by hand if you're running in a UNIX environment.  
Intermediate Action:
CP_cblia_sort_b4_pop This package contains a grammar and a template that will allow the Conversion Specialist to specify a sort before populate. The filter is to be placed at the target-unit level.  
CP_cia10_MrgOpt5n6 This package contains template changes to add merge_nomatch options 5 and 6.  
CP_cia_NT Package: CP_cia_NT Template Definitions to create batch files to run C intermediate actions on NT and template changes to allow the proc program to compile.  
CP_cia_csh_metascheduler Extract 3.3 and Higher ONLY. Splits the compile and execute into separate scripts.  
CP_cia_ksh_scripts Provides korn shell scripts for intermediate actions.  
Miscellaneous DSL Products:
CP_cbidms_grammars  
CP_Clickstream_100 Internal package demonstarting the use of cfs to read clickstream logs. The sample data in this package is from ETIs web servers.  
CP_dpropnr This package contains an add-on to the Cobol/IMS and Cobol/DB2 (non-DA) DSLs to permit generation of DPROPNR user exit routines. A user exit routine propagates changes from IMS to DB2. NOTE: The customer must already have installed Cobol/IMS and Cobol/DB2 (non-DA).  
CP_isi_data_cleanse This consultant package (CP) provides conversion, schema, and database objects to help integrate ETI EXTRACT and the ISI data cleanse products, Scrub, Dictionary and Match.  
CP_sort_control The ability to sort ascending and descending mixed keys for C/FS and COBOL/FS and sort optimization doc for Extract 3.2+  
CP_cbtd_301_bat Package: CP_cbtd_301_bat Provides bat scripts for the populate programs.  
CP_cifx_111p1 Three query template fixes: PDPR 5622, ORDER BY, and SQL DECLARE.  
CP_ctd_multiload_insert Package: CP_enhanced_multiload_insert Improves the multiload insert performance by having a NULLIF occur in the Values section of the insert instead of in the field declaration.  
CP_pl1_rs_converter Consultant Package used for converting data structure layouts. This package contains perl scripts that can be used to convert data structures from Assembler to COBOL, PL/1 to COBOL, or PL/1 to C.  
CP_rpg400 Update to RPG starter kit that includes updates to existing grammars and the addition of populate templates.  
CP_sassas_102_populate This package contains enhancements to the SAS starter kit version 1.0.2.  
CP_tbi_pop_only Package: CP_tbi_pop_only An initial version of a set of templates and grammars for COBOL/TurboIMAGE populate.  
cdataloader This is a starter package for the c_dataloader.  
Miscellaneous:
CP_conv_cstm_rpts Custom Report Templates. Reports on:  
CP_conv_scripts Package: CP_conv_scripts o conv-in-out.pl - script to read the exm file and report the programs, scripts to compile/execute programs, input and output files o clean-System-dir.pl - script to removed all the generated files below the System directory. o CP_rmConvDirWithNoConvObject - script to remove all conversion directories without a corresponding conversion in the MetaStore  
CP_html_report This package contain an REPORT template that produces a conversion report that is web based and a graphical component. This report is included in the release for shared objects 4.2.1 as part of the base product.  
CP_mapping_report This package creates a conversion mapping report including filter description information.  
CP_template_analysis  
CP_unix_sort Templates to generate script for Unix sort command.  
CP_unix_syncsort Package: CP_unix_syncsort Template and Template Libraries to generate bat files for Cobol/DB2. This package uses Template Libraries from Cobol/FS 4.2, so it must be installed prior to this package being installed.  
Impact Analyst:
CP_impact_analyst_web_qry Provides a web interface for the Impact Analyst Queries  
Toolkit Scripts:
CP_tk_ck_license This shell script, tk_ck_license.ksh , can be run to count how many licenses are currently being used; includes removing duplicates, showing one line per user name.  
CP_tk_nt_autobkup This perl script package can be used to delete old backup Extract files that are older than 5 generations.  
CP_tk_resync_schema Consultant Package for batch validation of conversions. This package will sync several schemas at one time in a batch mode. If there is a change to one schema and that schema is in several conversions, you can use this package to sync the schema in all of the conversions.  
CP_tk_who_edit This perl script package can be used to identify which users are currently using ETI Extract, what editor they may be in, and the metastores they are using as well. The benefit being identifying who may be using needed objects when multiple users are working on different metastores.  
CP_ksh_MS_Backup This korn shell script package can be used to backup all Extract Metastores contained in the ETI Extract Metastore Directory. This script should be run nightly before the file system backups.