Accessing SMAT database using Tcl script

To access a SMAT database using a Tcl script:

  1. package require sqlite
  2. sqlite3 db smatdbName
  3. db eval "PRAGMA KEY=<siteName"
    Ignore this step if the SMAT database is not encrypted.
  4. db eval "SELECT load_extension(‘sqlite3-regex.dll’)"
    Load sqlite3-regex.so on UNIX.
  5. db eval "sql to query"
  6. exit