This page is a generated page; the Consultant Package sourcebase ship list is called to generate this page.
| Interim Maintenance Consultant Packages: (Most Recent): | |
| Interim Maintenance Consultant Package (V01) for SAP/R3 2.10 Template libraries auto-attach on installation. | |
| 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 | |
| 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. | |
| 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. | |
| Interim Maintenance Consultant Package (V07) for csqlsvr_410. | |
| 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. |
| 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. |
| Consultant Package for coracle_da 4.2.1 . This package is used to simplify the ETI*Accelerator for C/MQSeries installation procedure. | |
| C/DB2: | |
| 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: | |
| 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: | |
| 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. |