+1 Software Engineering LLC

  Home  +   +  Tech Stuff  +  Contact Us

For Oracle, +1Copybook converts COBOL copybooks into CREATE TABLE and CONTROL files. SQL*Loader is used to load data.

Clients:
Bank of the West,
Wells Fargo Bank,
Britannia Building Society,
Kanbay International,
Syntel Limited,
Tangible Value LLC,
other S&P 500 Companies.
For SQL Server, +1Copybook converts COBOL copybooks into SQL Server CREATE TABLE and FORMAT files, converts EBCDIC data into ASCII, and loads data using BULK INSERT.

Clients:
Rosenfeld & Maidenbaum LLP, other California companies.
For Teradata, +1Copybook converts COBOL copybooks into CREATE TABLE scripts.

Clients:
Bank of the West



+1Copybook supports DB2.



View +1Copybook Command Line Options - May 2020

View Sample Oracle HTML Output

For Oracle, +1Copybook can:
  • Convert COBOL copybooks into CREATE TABLE scripts.
  • Generate the CONTROL files.
  • Convert EBCDIC data into ASCII delimited data.
  • Generate detailed HTML documentation.
  • Run the CREATE TABLE scripts.
  • Load the data using sqlldr.
If done by hand, these conversions can take literally months to do, are error prone (even when the data loads without errors), and is costly in both time and money.



View +1Copybook Command Line Options - May 2020

View Sample SQL Server HTML Output


For SQL Server, +1Copybook can:
  • Convert COBOL copybooks into CREATE TABLE scripts.
  • Generate the BULK INSERT and FORMAT files.
  • Convert EBCDIC data into ASCII delimited data.
  • Generate detailed HTML documentation.
  • Run the CREATE TABLE scripts and load data in one command.
With copybooks in the COPYBOOK directory and data files in DATA directory, the 5 steps above can occur by running just one command: cb -C -L



View +1Copybook Command Line Options - May 2020

View Sample Teradata HTML Output

For Teradata, +1Copybook can:
  • Convert COBOL copybooks into CREATE TABLE scripts.
  • Generate detailed HTML documentation.
Bank of the West used our +1Copybook product for Oracle and Teradata.

There was a problem though. Managers were upset that they didn't get their COBOL copybook conversions done within days because their license had expired. Managers became used to the quick turnaround our product provided them.



View +1Copybook Command Line Options - May 2020

View Sample DB2 HTML Output


For DB2, +1Copybook can:
  • Convert COBOL copybooks into CREATE TABLE scripts.
  • Generate the Method L DB2 load files to insert data.
  • Generate detailed HTML documentation.
We received multiple requests to support DB2, so today our product works with DB2. But we still need a customer (this can be you!) to test our product as we don't have a DB2 database to test with.



BSI Financial scheduled 3 months, 24x7 offshore work to convert FISERV COBOL Copybooks into CREATE TABLE and BULK INSERT scripts.

Using +1Copybook, we shortened BSI's schedule approximately 2.5 months, saving them both time and money.

What makes +1Copybook standout?
Unlike other tools viewable on YouTube which tend to use overly simplistic copybooks, +1Copybook can handle signed data, COMP-3, signed COMP-3, REDEFINES, OCCURS, and embedded OCCURS. For Oracle, EXTERNAL TABLES are supported. +1Copybook can convert EBCDIC data, including overpunched signed and COMP-3 data, into ASCII delimited data so the data can be loaded into a database.



+1 Software Engineering LLC
2390-C Las Posas Road, Suite 438
Camarillo, California 93010
805-586-3445 / john@plus1se.com


© 2020 +1 Software Engineering LLC - All Rights Reserved.

IBM, Microsoft, Oracle, and Teradata are database vendors and independent of +1 Software Engineering. Fiserv* is an American provider of financial services technology and is independent of +1 Software Engineering. Starbucks is used for promotional reasons only and is independent of +1 Software Engineering.