Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
Copybook Format
The format of a copybook is shown by the following example. This declaration defines the SQL Option EMPLOYEE table in the TUTORIAL location:
01 EMP-TABLE.
03 ENO PIC S9(4) COMP.
03 LNAME PIC X(10).
03 FNAME PIC X(10).
03 STREET PIC X(20).
03 CITY PIC X(15).
03 ST PIC XX.
03 ZIP PIC X(5).
03 DEPT PIC X(4).
03 PAYRATE PIC S9(13)V99 COMP-3.
03 COM PIC S9V99 COMP-3.
All sample tables are shown in the SQL Reference manual.