Example Data

NATURAL DDMs Based on the ADABAS Files

The CUSTOMERS DDM contains the description in the following output.

VIEW   : CUSTOMERS                           DEF.SEQ:   DBID:1   FNR:  45
COMMAND:
I T L DB NAME                          F LENG  S D       REMARK
- - - -- -----------bottom------------ - ----  - - ------------------
    1 CU CUSTOMER                      A 8.0     D
  G 1 SZ STATEZIP
    2 ST STATE                         A 2.0     D
    2 ZI ZIPCODE                       N 5.0
    1 CY COUNTRY                       A 20.0    D
    1 PH TELEPHONE                     A 12.0
    1 NA NAME                          A 60.0
    1 CN CONTACT                       A 30.0
    1 AD STREETADDRESS                 A 40.0
    1 CI CITY                          A 25.0
    1 FO FIRSTORDERDATE                N 6.0
  P 1 SL SIGNATURE-LIST
    2 LI LIMIT                         N 14.2
    2 SI SIGNATURE                     A 30.0
  M 1 BR BRANCH-OFFICE                 A 25.0
    1 SP STATE-ZIPLAST2                A 4.0
    1 SB ZIPLAST2                      N 2.0

EMPLOYEE DDM

The EMPLOYEE DDM contains the description shown in the following output.

EMPLOYEE DDM

VIEW   : EMPLOYEE                            DEF.SEQ:   DBID:1   FNR:  46
COMMAND:
I T L DB NAME                          F LENG  S D       REMARK
- - - -- ------------all-------------- - ----  - - ------------------
    1 ID EMPID                         N 6.0     D
    1 HD HIREDATE                      N 6.0
    1 SA SALARY                        N 7.2
    1 DP DEPT                          A 6.0
    1 JC JOBCODE                       N 5.0     D
    1 SX SEX                           A 1.0
    1 BD BIRTHDATE                     N 6.0
    1 LN LASTNAME                      A 18.0    D
    1 FN FIRSTNAME                     A 15.0
    1 MN MIDDLENAME                    A 15.0
    1 PH PHONE                         A 4.0

INVOICE DDM

The INVOICE DDM contains the description shown in the following output.

INVOICE DDM

VIEW   : INVOICE                             DEF.SEQ:   DBID:1   FNR:  47
COMMAND:
I T L DB NAME                          F LENG  S D       REMARK
- - - -- ------------all-------------- - ----  - - ------------------
    1 IB INVOICENUM                    N 5.0     D
    1 BT BILLEDTO                      A 8.0
    1 AM AMTBILLED                     N 14.2    D
    1 CY COUNTRY                       A 20.0    D
    1 AU AMOUNTINUS                    N 10.2
    1 BB BILLEDBY                      N 6.0     D
    1 BO BILLEDON                      N 6.0
    1 PO PAIDON                        N 6.0     D
    1 CX COMPUTEREXCHANGE              F 8.0   F

ORDER DDM

The ORDER DDM contains the description shown in the following output.

ORDER DDM

VIEW   : ORDER                               DEF.SEQ:   DBID:1   FNR:  48
COMMAND:
I T L DB NAME                          F LENG  S D       REMARK
- - - -- ------------all-------------- - ----  - - ------------------
    1 ON ORDERNUM                      N 5.0     D
    1 SN STOCKNUM                      N 4.0
    1 LN LENGTH                        N 4.0
    1 FC FABRICCHARGES                 N 10.2
    1 ST SHIPTO                        A 8.0     D
    1 DO DATEORDERED                   N 6.0
    1 DS SHIPPED                       N 6.0
    1 TB TAKENBY                       N 6.0
    1 PB PROCESSEDBY                   N 6.0
    1 SF SPECIALINSTRUCTION            A 1.0

Top of Page