+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.