Use the Demo Program from UNIX

  1. Install the Micro Focus XDBC software, accepting the default options in the installation script.
  2. Switch to the directory in which Micro Focus XDBC is installed, cd /d $GENESIS_HOME.
  3. Generate a default database configuration file using the sample script mfgenconf.sh.
  4. Generate the demonstration database with the sample script mfdemo.sh.

    This script

    • 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

    You can now use the command-line query tool to retrieve some information from the sample database you have just created.

  5. Enter mfsql.sh.
  6. Enter the SQL command:
    SELECT * FROM pets;

    This should retrieve the 19 records contained in the pets file:

    SQL (/? for help) ==> select * from pets;
    
     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
    
    SQL (/? for help) ==>
    
  7. You can exit the program by entering /q for quit.