Quick-start Demo Program

To become familiar with the AcuXDBC software quickly, follow this quick-start demo procedure:

  1. Ensure AcuXDBC is installed. (The easiest way to confirm this is to check for the existence of acxdbc.dll (Windows) or acuxdbc.so (UNIX/Linux) in the bin sub-directory of the install directory.)
  2. From a command or shell prompt, change to the install directory; this is the one indicated by the ACUCOBOL environment variable.
  3. Set the value of environment variable GENESIS_HOME to this directory.
  4. Ensure LD_LIBRARY_PATH or LIBPATH is set correctly (to the lib and bin sub-directories of the install directory).
  5. Change to the bin sub-directory (of the install directory).
  6. Run the genxconf batch/script job to generate a default database configuration file: genxconf.bat (Windows) or genxconf.sh (UNIX/Linux)

    This places the acuxdbc.cfg file, containing some default settings, in the install directory.

  7. Run the demo batch/script job to generate a demonstration database: demo.bat (Windows) or demo.sh (UNIX/Linux)
    This job:
    • Creates an empty system catalog, database system tables, and base views of the catalog.
    • Loads the system catalog with information from XFDs from a sample veterinary office application.
  8. Run the query tool: asql (Windows) or asql.sh (UNIX/Linux).

    The prompt changes to the following:

    SQL (/? for help) ==>
  9. Retrieve the contents of the pets table: type SELECT * FROM pets;

    The following result is returned:

    PATIENT_ID PATIENT_NAME ANIMAL_TYPE  BREED            TREATMENT   OWNER_ID 
    ---------- ------------ ------------ ----------       ---------   ------- 
     1          Cinnamon     Cat          Tabby              1         624 
     2          Nutmeg       Cat          Tabby              2         550 
     18         Shotzi       Dog          Schnauzer          1         704 
     36         Cinder       Dog          Poodle             4         221 
     54         Buster       Cat          Siamese            1         377 
     72         Missy        Bird         Parakeet           6         309 
     102        Kit          Dog          Shiba Inu          1         600 
     160        Milo         Dog          Chow               4         522 
     161        Puzzle       Reptile      Ball Python        3         522 
     328        Copper       Dog          Golden Retriever   4         618 
     377        Scooter      Cat          Domestic Shorthair 2         357 
     378        Scrapper     Cat          Devon Rex          2         357 
     379        Abbie        Cat          Maine Coon         2         357 
     480        Princess     Reptile      Iguana             1         309 
     503        Polly        Bird         Senegal Parrot     6         625 
     504        Diego        Bird         Red Lory           4         625 
     505        Alexi        Bird         African Grey       4         625 
     801        Hammy        Rodent       Gerbil             3         700 
     802        Rodney       Rodent       Hamster            4         700

    You can now experiment with other SQL commands to act upon the data (for example SELECT * FROM pets WHERE ANIMAL_TYPE='Dog';)

  10. When you have finished querying the database, type /q to quit the query tool.