Installing on UNIX Clients

If you are installing Micro Focus XDBC Server, follow the steps in section Installing on UNIX to install the server software if you have not already done so.

Note: If you will be using the unixODBC tool, see the topic To use the unixODBC driver.

Try to access a sample data file by entering: mfsql.sh

You should see information similar to the following:

  VORTEXsql - Simple Interactive SQL.
  Version 2.0.2.4 - Production.
  Copyright © 1989-2008, Trifox, Inc., California, USA.
  All Rights Reserved Worldwide.

Then enter: 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) ==>

To quit, enter /q.