SAS/ACCESS Interface to ADABAS Software

NATURAL DDMs Based on the ADABAS Files

This section shows descriptions of the NATURAL DDMs created for the preceding ADABAS files. The DDMS are presented in alphabetical order.

CUSTOMERS DDM

The CUSTOMERS DDM contains the description in CUSTOMERS DDM.

CUSTOMERS DDM

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 EMPLOYEE DDM.

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 INVOICE DDM.

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 ORDER DDM.

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

Chapter Contents
Previous
Next
Top of Page