+1 Software Engineering LLC
Home + + Demo + Tech Stuff + Contractors

+1Copybook Demo

Select Database:

DB2

Oracle

SQL Server

Teradata

Copybook:

DEMO TABLE

000001* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *   PLUSONE
000001*                       +1Copybook Demo                           PLUSONE
000001* Click Run +1Copybook now to convert copybook below or you can   PLUSONE
000001* enter a table name and upload a copybook on your system.        PLUSONE
000001* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *   PLUSONE
000001 01  PLUSONE.                                                     PLUSONE
000002   02  RECORD-KEY.                                                PLUSONE
000003     05  P1-ACCOUNT-NBR    PIC 9999999999.                        PLUSONE
000003     05  P1-ACCOUNT-NAME   PIC X(50).                             PLUSONE
000004     05  P1-ACCOUNT-CODE   PIC 9(5).                              PLUSONE
000005   02  P1-SAVINGS.                                                PLUSONE
000006     05  P1-LOAN-APPROVAL.                                        PLUSONE
000007         10  P1-APPROVAL-CD       PIC 9.                          PLUSONE
000009             88  ACTIVE                 VALUE 1.                  PLUSONE
000010             88  APPROVED               VALUE 2.                  PLUSONE
000011             88  REJECTED               VALUE 3.                  PLUSONE
000012             88  CANCELED               VALUE 4.                  PLUSONE
000014     05  P1-DATA.                                                 PLUSONE
000015         10  P1-GROUP-CD       PIC S9 COMP-3.                     PLUSONE
000016         10  P1-MGT-INC OCCURS 2 TIMES.                           PLUSONE
000016             15  P1-MGT-INC2 OCCURS 3 TIMES.                      PLUSONE
000018                 20  P1-PRINCIPAL-BAL     PIC S9(9)V99 COMP-3.    PLUSONE
000018                 20  P1-BUS-TYPE     PIC 99.                      PLUSONE
000018                 20  P1-STATUS-OUT   PIC X(2).                    PLUSONE
000018         10  FILLER            PIC X(5).                          PLUSONE
000016         10  P1-MGT-INC OCCURS 5 TIMES PIC X(5).                  PLUSONE
000022         10  P1-TOTAL-BAL      PIC S9(9)V99 COMP-3.               PLUSONE
000023         10  P1-DUE-DATE       PIC 9(08).                         PLUSONE
000033         10  P1-LAST-ACTVTY-DATE  PIC 9(08).                      PLUSONE
000034         10  P1-LAD REDEFINES P1-LAST-ACTVTY-DATE PIC X(8).       PLUSONE
000035         10  FILLER             PIC X(15).                        PLUSONE
000036         10  P1-DOWN-PYMT-CODE  PIC X.                            PLUSONE

Options:

Upper Case Mixed Case Lower Case
If copybook column contains DATE, DTE, or DT in name, define column as a DATE data type.
Add NOT NULL to each column in CREATE TABLE script.
Do not include FILLER columns in CREATE TABLE files.
Do not add counter 999 to FILLER column names.
View additional +1Copybook Command Line Options.

To upload a copybook found on your system, enter a database table name, choose file, then click upload copybook.

Table Name:

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

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