1. Downloaded compiled version of Sqlite package for AIX from:

http://teapot.activestate.com/package/list and looked for the sqlite packages for AIX

(I got the information from Support at Quovadx)

  1. Placed the downloaded file (libsqlite3.3.8.so) in the $HCIROOT/tclprocs directory; this makes it accessible to all sites.
  2. Ran the necessary command to build the pkgIndex file (similar to the tclIndex file). To do this, get into the tcl interpreter from the command line:
  3. Change directory to the $HCIROOT/tclprocs directory
  4. Type ‘hcitcl’
  5. From the hcitcl> prompt, enter the command:

pkg_mkIndex -verbose . *.so

(this builds the pkgIndex file to include any files ending in .so)

  1. From the hcitcl> prompt, verified the package was successfully installed by entering the following command:

package require sqlite

(should get a version number returned, i.e. 3.3.8)

  1. Then just played a little bit to see how it functions:

hcitcl>sqlite DBCMD mytest.db

hcitcl>DBCMD eval {CREATE TABLE "PID" (PATID VARCHAR NOT NULL PRIMARY KEY UNIQUE, NAME VARCHAR, ACCOUNT VARCHAR)}

hcitcl>DBCMD eval {INSERT INTO PID VALUES (1234,"Patient Name",8899)}

hcitcl>DBCMD eval {SELECT * FROM PID WHERE PATID = '1234'}

1234 {Patient Name} 8899

  1. There is information on the Sqlite website: http://www.sqlite.org/
  2. I also downloaded an IBM SQL Reference Manual (.pdf format) that I put on the T: drive under the Interface Engine folder (under an ‘SQL Reference’ folder). This has a lot of good information regarding SQL syntax

For those of you that installed both the host and client of Cloverleaf on your laptop/workstation (which I did), you can follow the same process to install the Windows compiled version of the sqlite package on your workstation. Download the Windows package, and put it in the C:\quovadx\qdx5.4.1\integrator\tclprocs directory and go through the rest of the steps. This will allow you to play with the sqlite via the tcl prompt locally.