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 acuxdbc.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.