Data structures for the example database files

 

These data structures are used in the application for the ATMTRANS, ATMS, and ACCTS files.

• ATMTRANS : /* Transaction record */

      ATMID      CHAR(5) (KEY)  /* ATM** machine ID number     */
      ACCTID     CHAR(5)        /* Account number            */
      TCODE      CHAR(1)        /* Transaction code          */
      AMOUNT     ZONED          /* Amount to be deposited or */
                                /* withdrawn                 */

• ATMS : /* ATM machine record */

      ATMN       CHAR(5)  (KEY) /* ATM machine ID number     */
      LOCAT      CHAR(2)        /* Location of ATM           */
      ATMAMT     ZONED          /* Total amount in this ATM  */
                                /* machine                   */

  ATMN LOCAT ATMAMT 10001 MN 200.00 10002 MN 500.00 10003 CA 250.00

• ACCTS: /* Accounting record */

      ACCTN      CHAR(5)  (KEY) /* Account number            */
      BAL        ZONED          /* Balance of account        */
      ACTACC     CHAR(1)        /* Status of Account         */

  ACCTN BAL ACTACC 20001 100.00 A 20002 100.00 A 20003 0.00 C

 

Parent topic:

Examples: Trigger programs